Power BI Course: Turn Your Data into Opportunities

Learn Microsoft Power BI Course

  • Start Date : 01/10/2022
  • Duration : 12 Hours
  • No. of Classes/ Sessions : 8
  • Registration Deadline : 30/09/2022
  • Batch No : 1
  • Class Schedule :
  • Fri (04:00 PM-05:30 PM)
  • Sat (04:00 PM-05:30 PM)
Power BI Course: Turn Your Data into Opportunities apply

Introduction

Power BI হল একটি ব্যবসায়িক বিশ্লেষণ টুল যা Microsoft দ্বারা বিভিন্ন ডেটা উৎস ব্যবহার করার জন্য দেওয়া হয় এবং আপনাকে সেই ডেটা কল্পনা করতে এবং আপনার অন্তর্দৃষ্টি শেয়ার করতে সাহায্য করে। এটি ইন্টারেক্টিভ ড্যাশবোর্ড এবং BI রিপোর্ট তৈরি করতে ব্যবহার করা হয় যাতে ব্যবসার পরিস্থিতি আরও ভালভাবে বুঝতে এবং বোঝা যায়।

  • বিজনেস ইন্টেলিজেন্স টুল
  • রিপোর্ট এবং ড্যাশবোর্ড
  • ক্লিনিং ডেটা
  • মডেলিং ডেটা
  • ডেটা ভিজ্যুয়ালাইজ করা
  • ডেটা শেয়ার করা

 

 

Prerequisites :

Basic Computer Knowledge. 

Training Modules :
  • What is Power BI
  • Why Power BI
  • How Power BI Works
  • How to Install 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
  • 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
  • Add, Subtract, Divide, Multiply
  • Percentage, Percent of, Modulo
  • Rounding the numbers
  • IsEven, IsOdd and Sign
  • 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 )
  • 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)
  • 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
  • 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, Go to Columns
  • 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
  • Understanding Data relationships
  • Creating relationships within tables
  • Cardinality
  • Column Chart
  • Stacked Column Chart
  • Pie Chart
  • Donut Chart
  • Funnel Chart
  • Ribbon Chart
  • Include and Exclude
  • Export data from Visual
  • 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
  • Line Chart
  • Drill down in Line Chart
  • Area Chart
  • Line vs Column Chart
  • Scatter Plot
  • Waterfall Chart
  • Tree Map
  • Gauge Chart
  • Number Card
  • Text Card
  • Date Card
  • Multi-Row Card
  • Filter on Visual
  • Filter on Page
  • Filter on All Pages
  • Drill through
  • Slicer for Text
  • Format Text Slicer
  • Date Slicer
  • Format Date Slicer
  • Number Slicer
  • Animated Bar Chart Race
  • Drill Down Donut Chart
  • Drill Down Column Chart
  • Word Cloud
  • Sankey Chart
  • Infographic
  • Play Axis
  • Scoller
  • Sunburst Chart
  • Histogram
  • 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
  • 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

Review

No Reviews yet
PRICE : TK. 3000
Contact info

+88 01714 121719

+88 02 41010090

[email protected]