Quality Training & Software Solution Provider

  1. Home
  2. Training

Power BI Course: Turn Your Data into Opportunities

Business Intelligence with Microsoft Power BI course imparts skills and knowledge to Analyze, Visualize and Report data. Power BI is a suite of tools for Business Analytics that allows corporate users to analyze data and get insights that can help in making right business decisions. This Power BI training covers the latest tools to monitor business growth and quickly get answers on any device through rich reporting features and dashboards. Learn how to connect and import your data, author reports, publish reports, create dashboards, and share with business users so that they utilize the business intelligence gathered in dashboards through the web as well as mobile devices.

Data is valuable if you can analyze & visualize it very well for business decision. Power BI is appropriate tool to analyze and visual the data and help to take right business decision.

The course is designed for the people who have basic knowledge in computing. Any professional who involves in business decision making process or helps decision makers by providing real time & actionable insights can join this course. This course is suitable for them who wants to build their career in Management Information System, Financial Analysis, Business Analytics & Strategic Business Planning related functions. Looking into the busy schedule of working people, we have schedule the class in the evening.

We follow a blended learning methodology with case-based hands-on training. The course coverage is given below-

Course Coverage   Trainer's Profile

1 - Introduction & installation

  • What is Power BI
  • Why Power BI
  • How Power BI Works
  • How to Install Power BI

2 - Text Functions in Power Query (Power BI)

  • Connecting to a database
  • Merge
  • Split and Trim
  • Upper, Lower and Proper
  • Add Suffix and Prefix
  • Left, Right and Mid
  • Extract Text with Delimiter

3 - Date Functions in Power Query (Power BI)

  • Year, Quarter, Month, Day
  • Difference between Dates, Earliest and Latest
  • Name of Day and Name of Month
  • Day of Week/Month/Year & Week of Month/Year
  • Extract Date from Date and Time
  • Calculate Age in 2 button Clicks
  • Which day of Year, Quarter, Month your Date of Birth is

4 - Number Functions in Power Query (Power BI)

  • Add, Subtract, Divide, Multiply
  • Percentage, Percent of, Modulo
  • Rounding the numbers
  • IsEven, IsOdd and Sign

5 - Appending Files and Tables in Power BI

  • Append multiple CSV Files from a folder
  • Append multiple Excel tables/Sheets from single file
  • Append Excel tables with different number of columns
  • Append multiple Excel files from a folder
  • Append different data source files in Power Query (Power BI )

6 - Merging Files and Tables in Power BI

  • Merge Tables/Sheets in Power Query (Power BI)
  • Merge Data from multiple Excel Files/Workbooks in Power Query (Power BI)
  • Merge Data from different Data Sources in Power Query (Power BI)
  • Merge data having multiple matching columns or multiple Criteria in Power Query (Power BI)

7 - Column from Examples and Conditional Column in Power BI

  • Column from Examples on Splitting Text
  • Column from Examples on Merging Text
  • Column from Examples on Date Column
  • Column from Examples on Alphanumeric Data
  • Conditional Column on One Column
  • Conditional Column on two columns
  • Conditional Column Comparing two column values

8 - Important Topics in Power BI

  • Fill down and Fill up
  • Grouping
  • Transpose
  • Unpivot
  • Data Types in Power Query (Power BI)
  • Replace Errors and Values
  • Keep Rows and Remove Rows
  • Add, Remove, Goto Columns

9 - M Language in Power Query

  • Introduction to M Language
  • M Functions - Date (ISIN)
  • M Functions - Date (Add and Subtract)
  • M Functions - Date (Day, Month, Week, Year)
  • M Functions - Text (Basic)
  • Writing a small M code in Power BI

10 - Understanding Data Models

  • Understanding Data relationships
  • Creating relationships within tables
  • Cardinality

11 - Basic Charts in Power BI

  • Column Chart
  • Stacked Column Chart
  • Pie Chart
  • Donut Chart
  • Funnel Chart
  • Ribbon Chart
  • Include and Exclude
  • Export data from Visual

12 - Table and Matrix in Power BI

  • Creating a Simple Table
  • Formatting in Table
  • Conditional Formatting in Table
  • Changing Aggregation in Table
  • Creating a Matrix in Power BI
  • Conditional Formatting in Matrix
  • Automatic Hierarchy in Matrix
  • Subtotal and Grand Total
  • Number Formatting in Table and Matrix

13 - Other Charts in Power BI Desktop

  • Line Chart
  • Drill down in Line Chart
  • Area Chart
  • Line vs Column Chart
  • Scatter Plot
  • Waterfall Chart
  • Tree Map
  • Gauge Chart

14 - Cards and Filters in Power BI

  • Number Card
  • Text Card
  • Date Card
  • Multi-Row Card
  • Filter on Visual
  • Filter on Page
  • Filter on All Pages
  • Drill through

15 - Slicers in Power BI

  • Slicer for Text
  • Format Text Slicer
  • Date Slicer
  • Format Date Slicer
  • Number Slicer

16 - Advanced Charts in Power BI

  • Animated Bar Chart Race
  • Drill Down Donut Chart
  • Drill Down Column Chart
  • Word Cloud
  • Sankey Chart
  • Infographic
  • Play Axis
  • Scoller
  • Sunburst Chart
  • Histogram

17 - DAX Operations

  • What is DAX & Power Pivot?
  • Our first DAX measure
  • Understanding the Power Pivot Calculation Engine & Evaluation Context
  • Formatting the DAX measures
  • Reusability of DAX measures
  • IF Condition in DAX
  • DISTINCTCOUNT in DAX
  • MIN / MAX / AVERAGE
  • CALCULATE in DAX
  • Adding columns with DAX
  • Alternate syntax for CALCULATE()
  • Variables in DAX

18 - Power BI Service Introduction

  • Creating a Superstore Report
  • Create an Account on Power BI Service
  • Publish Report to Power BI Service Account
  • Export (PPT, PDF, PBIX) Report and Share
  • Comment, Share and Subscribe to a report
  • Create a dashboard in Power BI Service
  

Having 18 years of experiences on Conducted IT consultancy and training in the core area of SQL, SQL Server, C, C++, Python, MS Excel, Power BI, Data Science & Machine learning using Python, Machine learning algorithm, UML with proven skill.

Also have the experiences on Business Analysis, Project Management, User Engagement, Service Operation, Systems Management and IT Innovation. Large ERP, with proven records for success of delivering service into robust IT infrastructure, ERP Systems Operations like Hospital Management Information System (HMIS).

I like to strive to position myself further with leadership and management challenges in a leading role through working in different cultural or business environment. More over a lots of experience in software coding, planning, designing, customization, implementation, technical support and training. Specialized in C# .Net, SQL Server, PHP, MySQL, HTML5 for web based application. Also experienced in networking installation, maintenance, security and administration.

Course Schedule

Sun-Tue-Thu, 7:30PM - 9:00PM

Starting On: 3rd Nov 2022

Duration: 12 Hours

Mode: Online
Course Fee & Payment Mode
Course Fee:
BDT 3,000+VAT

 

Payment Options:

1. bKash: 01738442377

2. Bank:
MEEK Technologies Ltd.,
A/C: 7022-0212000985,
Trust Bank Ltd,
Millennium Corporate Branch,
Dhaka.

 
Contact Us
Phone: 01910607050, 01873361245, 01738442377
email: meektechnologies@gmail.com

 
Register Now
 
Pay Fees Now