Zain Sohail

Academic

Career

Verbatim text

Automated Business Intelligence Reporting Solution (ABRS) 
 
The Automated BI reporting solution with the help of three-layered architecture and ELT along with 
Power BI will provide the user with business insights. User can also view the current patterns in the 
measures with respect to one or multiple dimensions for taking informed decisions.  
The source data was dumped into a data lake, to ensure the data sanity. After that business rules 
and logics were implemented and surrogate keys were populated, and data was loaded into the 
integration layer. Finally depending upon the use cases the aggregated data was stored in the 
semantic layer. BI Tool was connected to the semantic layer for the implementation of business 
reports and dashboards. These reports are embedded in our pleasing and stylish front-end which 
we made on React. Retail data set known as Adventure Works is being used for implementing five 
use cases which includes sales, product, purchase/vendor, person and shipment use cases. Most 
importantly, 
it’s 
all 
done 
on 
Big 
Data 
tools 
and 
technologies.                    
Features include: 
- The three layered model mentioned above eradicates all data issues and saves time and 
CPU/Memory resources as aggregated data is stored in a separate layer. 
- Provide the user with business insights  
- User can also view the current patterns in the measures with respect to one or multiple 
dimensions for taking informed decisions. 
- Creation of data pipeline (Data transformation, data cleansing , data integration)  
-  Dashboards and reports on Power BI (Easy to understand about patterns) 
- Only specific user can log in to view analytics section on website made on react. 
 
 
Technology Used: 
Cloudera, Impala, HiveQL, Hadoop, Power BI, 
 Java script,  CSS, Bash, SQL, React Framework  
Supervisor Name: 
Dr. Ejaz Ahmed 
Group Members:   
Zain Sohail(I17-0016) 
Zaeem Ansari(I17-0353) 
Hashir Akbar(I17-0080)

AI enrichment