Analyzing Data with Excel and Power BI Track (42Hrs. )

Analyzing Data with Excel and Power BI Track (42Hrs. )


The main purpose of this track is to give audiences the ability to analyze their business data using BI techniques.

 Here, you can  add BI techniques your business data. Go beyond the capabilities of tables ,charts and uses Pivot Tables and Charts, the Excel Data Model and Analysis Tool pack, and Power BI.



Nowadays, Business Enterprises rely heavily on Data Analysis and Data Science, this is in an alignment with management by objectives, Data Scientist and Data Analyst became the most important functions and the highly income jobs as well , Insights Academy offer this track as the first step in such amazing field for any Business User

After completing this course you can professionally display and analyze the results of your business, teamwork, and organization using Power BI and Excel which is the most useful Self -Service Business Intelligence technologies, as well as you will start enjoying access to your Business Data Insights

Program Added Value | After completing this program, audiences will be able to

  • Create and Formatting Measures and KPIs, Create PivotCharts, Use cube functions, and Construct graphs that can summarize the information retrieved by using cube functions.
  • Build Excel Data Model, Connect to databases, transform the data into a convenient form, and load the data into Excel tables or into the Data Model.
  • Transform formatted Excel reports into usable data to perform further analysis.
  • Use the key visualizations in Power BI and describe the rationale for self-service BI.
  • Use Q&A to ask questions in natural query language, and create content packs and groups.
  • Use the Microsoft Power BI suite of tools to connect to a wide variety of data sources. These include the main industry-standard databases, Microsoft cloud-based services—Microsoft Azure SQL Database, Azure Data Lake, and Azure Machine
  • Learning—alongside Microsoft Excel® and other files, and software as a service (SaaS) providers such as Microsoft Bing®, Facebook, and MailChimp.
  • Goes behind the scenes of the visualizations, and explores the techniques and features on offer to shape and enhance your data, and create attractive reports, while helping to find hidden insights into data.
  • Use Excel Analysis ToolPak to get insights from your data

After completing this program, audiences will be able pass the following exams

  • Exam 70-779 : Analyzing and Visualizing Data with Microsoft Excel
  • Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI.


Attendees Required Resources:

Personal Laptop with at least Windows 10 & Office 2016 is required to access course LAB


Additional information



Start Date

For Saturday (s) Morning : 2 March 2019
For Sunday(s) and Wednesday (s)Evening: 3 March 2019


There are no reviews yet.

Be the first to review “Analyzing Data with Excel and Power BI Track (42Hrs. )”

Your email address will not be published.

You may also like…