What Is Excel BI?
Excel BI is a powerful, flexible tool for every analytics activity. It gives you broad data analytics and visualization capabilities.
Excel BI Consist Of:
- Power Query
- Power Pivot
Note: Available in Excel 2010 & above.
Power Pivot is an Excel add-in which can used to perform powerful data analysis and create sophisticated data models. It can handle large volumes of data (millions of rows) from various sources and all of this within a single Excel file.
Power Pivot enables you to import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous data, create calculated columns and measures using formulas, build PivotTables and PivotCharts, and further analyze the data so that you can make timely business decisions without requiring IT assistance.
Note: You DO NOT need any programming, Excel VBA coding or SQL knowledge to start using Power Query.
Power Query is a tool that can be used for data discovery, reshaping the data and combining data ( Merge / Blend / Consolidate, etc.) coming from different sources.
Power Query can connect directly to Excel, Access, Text, CSV, Hadoop, Sales Force, Azure and many other different sources of data.
Power Query :
- A tool that can extract / connect to data from almost any source.
- Merge and shape data sourced to match your data analysis requirements.
- Prepare your data for further analysis and modelling by tools like Power Pivot, etc.
- Keeps sequential record of all the steps performed from source till final output.
You can review your automation steps later and easily modify it.
DAX stands for Data Analysis Expressions. DAX is a formula language and is a collection of functions, operators, and constants that can be used in a formula or expression to calculate and return one or more values. DAX is the formula language associated with the Data Model of Excel Power Pivot.
It is not a programming language, but is a formula language that allows the users to define custom calculations in calculated columns and calculated fields (also known as measures). DAX helps you create new information from the data that is already present in your Data Model. DAX formulas enable you to perform data modeling, data analysis, and use the results for reporting and decision making.
- People performing Data Analytics in Excel.
- Business Intelligence Developers.
- Specialists using Excel.
- Business Analysts
- Data Analysts
- Financial Analysts using Excel
- If you or your team needs to fetch data from different sources and transform it so that it can be used in Excel for further analysis, then this course will help you master Power Query features from scratch.
- IT specialists who performs Extract Transform & Load (ETL) activities for business
Participants attending this training should be familiar with the Advanced Excel topics such as VlookUP, Pivot table, Match & Index, Power functions like CountIF, SUMIF, IF condition,etc.
If the mentioned topics are not familiar, we recommend a 2 Day’s Advance Excel Workshop.