Spoken English
Aptitude & Reasoning
Microsoft Excel
Business Product Strategy
Brand Identity
Content Marketing Basics
Create a WordPress Website
Email Marketing
Copywriting
SEO (Search Engine Optimization)
Facebook Groups
Facebook Pages
Facebook Creator Studio
Facebook Ads
Facebook Retargeting
Facebook For Local Business
Google Ads
Google Analytics
Google My Business
Twitter Marketing
Instagram Marketing
Pinterest Marketing
LinkedIn Marketing
Social Media Live Streaming
YouTube Marketing
Video Marketing & Video Production
Podcasting
Quora
Power BI
Agile Scrum
Interview Preparation

1) Basic Grammar Knowledge

• Parts of the speech
• Types of the sentences
• 12 active voice tenses.
• 8 passive voice tenses.
• Use of articles.
• Use of prepositions.
• Modal auxiliaries.
• Clauses
• Direct and indirect speech.
• Some special constructions like feel like going to, had better, used to, as if, be, get, prefer to.

2) Essential English Vocabulary

• Verbs
• Nouns
• Adjectives
• Adverbs
• Prepositions
• Interjections
• Conjunctions

3) Speaking practice

• Self-introduction.
• Daily routine.
• My family.
• My village/city.
• My school.
• My hobby.
• My favorites.

1. Quantitative Ability (Basic Mathematics)

• Number Systems
• LCM and HCF
• Decimal Fractions
• Simplification
• Square Roots and Cube Roots
• Average
• Problems on Ages
• Surds & Indices
• Percentages
• Problems on Numbers

2. 
   Quantitative Ability (Applied & Engineering Mathematics)

• Logarithm
• Permutation and Combinations
• Probability
• Profit and Loss
• Simple and Compound Interest
• Time, Speed and Distance
• Time & Work
• Ratio and Proportion
• Area
• Mixtures and Allegation

3. Data Interpretation

• Data Interpretation
• Tables
• Column Graphs
• Bar Graphs
• Line Charts
• Pie Chart
• Venn Diagrams

4. Logical Reasoning (Deductive Reasoning)

• Analogy
• Blood Relation
• Directional Sense
• Number and Letter Series
• Coding – Decoding
• Calendars
• Clocks
• Venn Diagrams
• Seating Arrangement
• Syllogism
• Mathematical Operations

• • Getting Acclimated with EXCEL, Basic EXCEL Formulas & Functions , Text, Times, and Dates Data Formats, Pivot Table, Introduction to Statistics in EXCEL , Handling Data in EXCEL, Pivot Tables, Charts in Excel

• Metric Design
• How to crack Product and Strategy Rounds
• Domain Knowledge – Banking, Finance, Marketing, Social Media, Operations, Healthcare
• Experiment Design Advanced

• Branding Basics
• Tools for Creating Graphics
• Brand Assets: Links to Helpful Resources
• Quick Canva Tutorial
• Quick Photoshop Tutorial
• Supplemental Reading List

• What is Content Marketing?
• Your Content Marketing Plan

• Intro to the WordPress Course Lessons
• Purchase Hosting and Install WordPress
• Navigating WordPress
• Install a New Theme
• Add a Static Home Page
• Editing a Page & Change the Site Title
• Add and Edit a Menu
• Publishing Your Website
• Writing a New Post & Organizing Your Blog
• Blog Page Design – Excerpts vs. Full Content
• Adding a Video to Your Website
• Customize the Sidebar
• Change Your Site Icon
• Change Your Site Icon with a Plugin
• Make Your Website Responsive and Mobile Friendly
• Customize the Footer Information
• Find, Install, and Activate Plugins
• Backing Up Your Website
• Securing Your Site from Attackers
• Make Your Site SEO Friendly
• Make Your Website Faster
• See Google Analytics in WordPress
• Block Spam with Akismet
• Pretty Link Redirects and Link Shortener
• SSL Certificates – Secure & Encrypt User Data
• Important Message About the Next Lesson
• Secure Contact Forms
• Add Comments
• Free Email Marketing in WordPress
• Add Social Sharing Buttons
• What Pages Do You Need?
• Design a Home Page that Works
• The Start Here (About Page)
• The Resources Page

Easy Email Marketing Funnels
Email Marketing Tools
Create a Lead Magnet
Add Opt-In Forms to Your Website
Segment and Tag Your Audience
Create Email Sequences
Write Better Email Subject Lines
Use Reports to Analyze Success

Copywriting Basics
A.I.D.A.
9 Commandments of Copywriting
Write Better Headlines
Write Quality Articles
Improve Your Website’s SEO
Tips for Better Email Copy
How to Make People Open Your Emails
Qualities of an Effective Promotional Email
Examples of High Quality Emails
Email Copywriting Case Study
Tips for Better Social Media Copy
Social Media Best Practices
T.H.I.N.K. Before You Post
Social Media Copywriting Case Study
Supplemental Reading List

Introduction to SEO and why it’s important for your business
10 crucial SEO ranking factors you need to know
What are keywords and why they are important?
The best keyword research tools
Domain authority and trustworthiness
Optimizing your WordPress website
Migrating your website from Http to Https
Checking your website page speed
More advanced techniques
Optimizing your website with the Yoast SEO plugin
SEO strategy to establish your business and brand online
The importance of backlinks
Great ideas to unlock the power of backlinks
Create a Google My Business profile
Key point review

Why Facebook Groups?
Start a Facebook Group for Your Audience
Create Your Facebook Group
How to Grow Your Online Community
How to Create More Engagement in Your Community
Best Types of Posts to Share in Your Group
Make Consistent Posting Easier
Content Tools & Apps I Love to Create and Automate Posts
Make Your Posts Count More and Increase Engagement
Use Analytics to Grow Your Community

Why Facebook Pages are Important for your Business
Join Our Course Private Facebook Group
Creating an Optimized Facebook Page for your Business
Connecting WhatsApp with your Facebook Page
Adding Essential Information to your Facebook Page
Getting your Facebook Page Username & URL
Create your Facebook Page
Top 9 Ways to Monetize your Facebook Page
Exploring Publishing tools
Facebook Call-To-Action Button
How to Spy your Competitors on Facebook
How to Guarantee your Fans see All your posts
Exploring Facebook Insights
Promoting your Facebook Page
Four Unlimited sources of Royalty Free Image for your Facebook
Turn ANY image into a clickable Facebook Post

Introduction to the Facebook Creator Studio
Scheduling posts with the Creator Studio for Facebook and Instagram
Facebook Insights – Valuable data for your business
Assignment: Post and schedule with the Facebook Creator Studio

Introduction to Facebook Ads
Creating your Facebook Business account
Introduction to the Facebook Ads Manager
Setting up your Payment account for Ads
Defining your Target Audience
Level 1 – Boost your Facebook Post
Level 2 – Creating your Ad in the Ads Manager
Tips to get your Ad approved by Facebook
Analyzing the Results
Creating you First Facebook Ad

What is Facebook Retargeting and Why is Important for you
Creating a Facebook Pixel
Installing the Pixel in WordPress
Installing the Pixel in other websites (non-Wordpress)
Installing the Facebook Pixel on your Website.
Testing the Facebook Pixel
Creating an Audience of everyone that visited your website
Creating an Audience of people that sited specific pages
Creating your Optimized Facebook Ad with the Pixel

How Facebook Ads Can Help your Local Business to Grow
This is the Plan for your Local Business
Reaching people around your business
Creating your Local Business Facebook Ad
Create a Facebook Ad for your Local Business

What is Google Ads and why is it important to you?
Types of Google Ads that we can create
Creating your Google Ads account step by step
Exploring the Google Ads interface and identifying key components
Setting up your Google Ads account billing information
Assignment: Creating your Google Ads account
The 3 main elements of your campaigns
What are keywords and why are they essential?
Finding top keywords for your company with Google Keyword Planner
Assignment: Finding the best keywords for your business
The structure of a campaigns in Google Ads
Creating a Google Ads Search campaign
Creating a Google Ad Display campaign
Creating a Google Ad Video campaign for YouTube
Assignment: Creating your Google Ad Campaign

Set Up Google Analytics
Navigating the Google Analytics Dashboard
Know Your Audience Better with Analytics
User Acquisition and Behavior Flow
See Where Visitors Click on Your Website
User Behavior and Site Speed
Setting Up Goals with Google Analytics

Welcome to Google My Business
Why Google My Business is important to your brand
Creating your Google My Business
Getting to know the Google My Business interface
Understanding Google Ranking My Business
Optimizing your Business information
Optimizing your Business description
Products to Google My Business
Services on Google My Business
Why reviews are essential to your business
Creating your review strategy

Why Twitter and How it can Help your Business
Choosing the Best Username
4 Tips to Choose Your Twitter Handle
Creating your Twitter account
Creating an Outstanding Twitter Profile Page
Adding your Profile and Header Photo
Writing an Optimized Twitter Bio
Write an Optimized Twitter Profile Description
Pin the Most Important Tweet for Your Audience
Connecting with Other Influencers
Twitter Hashtags
Case Study – Growing Your Twitter presence with Jooicer
Adding Twitter buttons to your Website
Adding Twitter Widgets to your Website
Twitter Advertising – Creating your Ads Account
Twitter Advertising – Adding your Payment Method
Twitter Advertising – Creating other Twitter Ads
Twitter Advertising – Promoting a Tweet

Why Instagram and How it can Help your Business
Instagram for Business – What’s our Strategy
Create an Instagram for Business Profile
Accessing the Ads Manager
Creating your First Instagram Ad
Creating your Instagram Ad inside the App
Create an Instagram Ad!
Important Tips to have a successful Ad campaign
WordSwag – Tools to Create Viral Instagram Photos
WordSwag – Create Viral Instagram Photos
WordSwag – Adding Your Logo or Website to your Instagram Photos
Instagram Live Video
Case Study: How Phil Uses Instagram to Grow His Business

Why Pinterest and How it can help your Business
Opening a Pinterest Business Account
Linking Pinterest with Your Website and Getting a Verified Account
Linking Pinterest with Other Social Media Platforms
Optimizing your Pinterest Profile
Creating Boards
Create two Pinterest Boards in your Profile
Using “Secret” Boards
The Powerful Pinterest Notification
Adding Pinterest Chrome Extension
Adding Pinterest to Your Website
Pinterest Ads – Getting Started
Pinterest Ads – The Ads Panel Overview
Pinterest Ads – Creating a Campaign
Pinterest Ads – Creating Pinterest Ads Fast
The Official Pinterest Ads Manager Guide (Download)
Pinterest Ads – Analytics

Welcome to LinkedIn Marketing
Setting up your LinkedIn Profile
Adding Experience, Skills, Accomplishments to your Profile
Adding a Professional Background Photo
Adding Media (video/photos) to your LinkedIn Profile
Changing your LinkedIn URL
Adding Your Website to LinkedIn
Creating Shareable Content on LinkedIn
Case Study: LinkedIn Company Page Examples
Creating a LinkedIn Company Page
Managing your LinkedIn Company Page
Publishing content in your LinkedIn Company Page
Getting $50 Bonus in Ads Credits
LinkedIn Ads Introduction
Creating a LinkedIn Sponsored Content Ad
Waiting for LinkedIn Ad approval
Creating a LinkedIn Text Ads Campaign
Creating a LinkedIn Sponsored InMail Campaign
Quick view at the Campaign Manager
Create an Optimize your LInkedIn Profile

Growing your Business with LIVE streaming
Basic Equipment for Social Media Streaming
Case Study: Phil’s Livestream Setup
Planning an Irresistible Live Streaming Session
Facebook Live Basics
Running a Facebook Live Session from your Smartphone
Sharing our Facebook Live Session
3 ways to Reuse your Facebook Live Session for Ads or Posts
YouTube Live – Going live from your computer
YouTube Live – Going live from your smartphone
Instagram Live – Going live on Instagram
Introduction to OBS Broadcaster software
Setting up your OBS Software
Using OBS Studio Mode
Facebook Live Streaming with OBS
YouTube Live Streaming with OBS
Simultaneous Streaming to Facebook, YouTube and other platforms
BeLive – Streaming software alternative
Let’s do a Social Media Live Streaming Session!

Intro to YouTube Marketing
How to Promote Your Business with YouTube
Best Practices for Marketing on YouTube
Case Study: How Phil Uses YouTube to Grow His Business
YouTube Crash Course: How to Start a Channel
ACTION ITEM: Create Your YouTube Channel
YouTube Crash Course: How to Customize Your Channel
YouTube Crash Course: Channel Settings
YouTube Crash Course: Creator Studio Tour
YouTube Crash Course: Using Analytics
Uploading a Video
Increase YouTube Subscriptions by 400%
YouTube Crash Course: How to Promote a Video as a YouTube Ad
TubeBuddy: Optimize Your YouTube Experience
Spy on Your Competitors with Social Blade

Video Marketing Basics
Video Equipment for Beginners
Tools to Help Make Your Videos Look Pro
Structure a Video that Sells
Video Production Bootcamp Intro
You Need These Things to Make a Great Video
Create the RIGHT Video for Your Brand
Come Up with a GREAT Video Idea
Plan Your Video
Intro to Equipment
Camera Options
Microphone Options
Lighting Options
Editing Tools
Exposing Your Shot
Compose Your Shot
Filming Yourself
Getting the Right Shot
Choose a Background
Phil’s Office Setup
Shooting with a Smartphone
Choosing the Right Microphone
Record Better Audio in Any Environment
Basic Video Lighting: 3-Point Setup

Why Podcasting?
Case Study: Phil’s Top-of-the-Funnel Limited Series Podcast
Recommended Tools for Podcasting
Recommended Platforms to Share a Podcast
Coming Up with Your Podcast Idea
Tips for Recording Your Podcast
Tips for Editing Your Podcast
Publishing Your Podcast with Libsyn
Publishing Your Podcast with Anchor
Case Study: Different Styles of Podcasts
Bonus Lesson: Adding Tags to Your MP3 with ID3 Editor
Outsourcing Your Podcast Work

Why Quora?
Find the Right Questions, and Optimize Your Answer

Introduction To Power BI

• Introduction to Power BI – Need, Imprtance

• Power BI – Advantages and Scalable Options

• History – Power View, Power Query, Power Pivot

• Power BI Data Source Library and DW Files

• Cloud Colloboration and Usage Scope

• Business Analyst Tools, MS Cloud Tools

• Power BI Installation and Cloud Account

• Power BI Cloud and Power BI Service

• Power BI Architecture and Data Access

• OnPremise Data Acces and Microsoft On Drive

• Power BI Desktop – Instalation, Usage

• Sample Reports and Visualization Controls

• Power BI Cloud Account Configuration

• Understanding Desktop & Mobile Editions

• Report Rendering Options and End User Access

• Power View and Power Map. Power BI Licenses

• Course Plan – Power BI Online Training

Creating POWER BI Reports, Auto Filters

• Report Design with Legacy & .DAT Files

• Report Design with Databse Tables

• Understanding Power BI Report Designer

• Report Canvas, Report Pages: Creation, Renames

• Report Visuals, Fields and UI Options

• Experimenting Visual Interactions, Advantages

• Reports with Multiple Pages and Advantages

• Pages with Multiple Visualizations. Data Access

• PUBLISH Options and Report Verification in Cloud

• “GET DATA” Options and Report Fields, Filters

• Report View Options: Full, Fit Page, Width Scale

• Report Design using Databases & Queries

• Query Settings and Data Preloads

• Navigation Options and Report Refresh

• Stacked bar chart, Stacked column chart

• Clustered bar chart, Clustered column chart

• Adding Report Titles. Report Format Options

• Focus Mode, Explore and Export Settings

Report Visualization And Properties

• Power BI Design: Canvas, Visualizations and Files

• Import Data Options with Power BI Model, Advantages

• Direct Query Options and Real-time (LIVE) Data Access

• Data Fields and Filters with Visualizations

• Visualization Filters, Page Filters, Report Filters

• Conditional Filters and Clearing. Testing Sets

• Creating Customized Tables with Power BI Editor

• General Properties, Sizing, Dimensions, and Positions

• Alternate Text and Tiles. Header (Column, Row) Properties

• Grid Properties (Vertical, Horizontal) and Styles

• Table Styles & Alternate Row Colors – Static, Dynamic

• Sparse, Flashy Rows, Condensed Table Reports. Focus Mode

• Totals Computations, Background. Borders Properties

• Column Headers, Column Formatting, Value Properties

• Conditional Formatting Options – Color Scale

• Page Level Filters and Report Level Filters

• Visual-Level Filters and Format Options

• Report Fields, Formats and Analytics

• Page-Level Filters and Column Formatting, Filters

• Background Properties, Borders and Lock Aspect

Chart And Map Report Properties

• CHART Report Types and Properties

• STACKED BAR CHART, STACKED COLUMN CHART

• CLUSTERED BAR CHART, CLUSTERED COLUMN CHART

• 100% STACKED BAR CHART, 100% STACKED COLUMN CHART

• LINE CHARTS, AREA CHARTS, STACKED AREA CHARTS

• LINE AND STACKED ROW CHARTS

• LINE AND STACKED COLUMN CHARTS

• WATERFALL CHART, SCATTER CHART, PIE CHART

• Field Properties: Axis, Legend, Value, Tooltip

• Field Properties: Color Saturation, Filters Types

• Formats: Legend, Axis, Data Labels, Plot Area

• Data Labels: Visibility, Color and Display Units

• Data Labels: Precision, Position, Text Options

• Analytics: Constant Line, Position, Labels

• Working with Waterfall Charts and Default Values

• Modifying Legends and Visual Filters – Options

• Map Reports: Working with Map Reports

• Hierarchies: Grouping Multiple Report Fields

• Hierarchy Levels and Usages in Visualizations

• Preordered Attribute Collection – Advantages

• Using Field Hierarchies with Chart Reports

• Advanced Query Mode @ Connection Settings – Options

• Direct Import and In-memory Loads, Advantages

Hierarchies And Drilldown Reports

• Hierarchies and Drilldown Options

• Hierarchy Levels and Drill Modes – Usage

• Drill-thru Options with Tree Map and Pie Chart

• Higher Levels and Next Level Navigation Options

• Aggregates with Bottom/Up Navigations. Rules

• Multi Field Aggregations and Hierarchies in Power BI

• DRILLDOWN, SHOWNEXTLEVEL, EXPANDTONEXTLEVEL

• SEE DATA and SEE RECORDS Options. Differences

• Toggle Options with Tabular Data. Filters

• Drilldown Buttons and Mouse Hover Options @ Visuals

• Dependant Aggregations, Independant Aggregations

• Automated Records Selection with Tabular Data

• Report Parameters : Creation and Data Type

• Available Values and Default values. Member Values

• Parameters for Column Data and Table / Query Filters

• Parameters Creation – Query Mode, UI Option

• Linking Parameters to Query Columns – Options

• Edit Query Options and Parameter Manage Entries

• Connection Parameters and Dynamic Data Sources

• Synonyms – Creation and Usage Options

Power Query & M Language

• Understanding Power Query Editor – Options

• Power BI Interface and Query / Dataset Edits

• Working with Empty Tables and Load / Edits

• Empty Table Names and Header Row Promotions

• Undo Headers Options. Blank Columns Detection

• Data Imports and Query Marking in Query Editor

• JSON Files & Binary Formats with Power Query

• JavaScript Object Notation – Usage with M Lang.

• Applied Steps and Usage Options. Revert Options

• creating Query Groups and Query References. Usage

• Query Rename, Load Enable and Data Refresh Options

• Combine Queries – Merge Join and Anti-Join Options

• Combine Queries – Union and Union All as New Dataset

• M Language : NestedJoin and JoinKind Functions

• REPLACE, REMOVE ROWS, REMOVE COL, BLANK – M Lang

• Column Splits and FilledUp / FilledDown Options

• Query Hide and Change Type Options. Code Generation

DAX EXPRESSIONS – Level 1

• Purpose of Data Analysis Expresssions (DAX)

• Scope of Usage with DAX. Usabilty Options

• DAX Context : Row Context and Filter Context

• DAX Entities : Calculated Columns and Measures

• DAX Data Types : Numeric, Boolean, Variant, Currency

• Datetime Data Tye with DAX. Comparison with Excel

• DAX Operators & Symbols. Usage. Operator Priority

• Parenthesis, Comparison, Arthmetic, Text, Logic

• DAX Functions and Types: Table Valued Functions

• Filter, Aggregation and Time Intelligence Functions

• Information Functions, Logical, Parent-Child Functions

• Statistical and Text Functions. Formulas and Queries

• Syntax Requirements with DAX. Differences with Excel

• Naming Conventions and DAX Format Representation

• Working with Special Characters in Table Names

• Attribute / Column Scope with DAX – Examples

• Measure / Column Scope with DAX – Examples

DAX EXPRESSIONS – Level 2

• YTD, QTD, MTD Calculations with DAX

• DAX Calculations and Measures

• Using TOPN, RANKX, RANK.EQ

• Computations using STDEV & VAR

• SAMPLE Function, COUNTALL, ISERROR

• ISTEXT, DATEFORMAT, TIMEFORMAT

• Time Intelligence Functions with DAX

• Data Analysis Expressions and Functions

• DATESYTD, DATESQTD, DATESMTD

• ENDOFYEAR, ENDOFQUARTER,ENDOFMONTH

• FIRSTDATE, LASTDATE, DATESBETWEEN

• CLOSINGBALANCEYEAR,CLOSINGBALANCEQTR

• SAMEPERIOD and PREVIOUSMONTH,QUARTER

• KPIs with DAX. Vertipaq Queries in DAX

• IF..ELSEIF.. Conditions with DAX

• Slicing and Dicing Options with Columns, Measures

• DAX for Query Extraction, Data Mashup Operations

• Calcualted COlumns and Calculated Measures with DAX

Power BI Deployment & Cloud

• PowerBI Report Validation and Publish

• Understanding PowerBI Cloud Architecture

• PowerBI Cloud Account and Workspace

• Reports and DataSet Items Validation

• Dashboards and Pins – Real-time Usage

• Dynamic Data Sources and Encryptions

• Personal and Organizational Content Packs

• Gateways, Subscriptions, Mobile Reports

• Data Refresh with Power BI Architecture

• PBIX and PBIT Files with Power BI – Usage

• Visual Data Imports and Visual Schemas

• Cloud and On-Premise Data Sources

• How PowerBI Supports Data Model?

• Relation between Dashboards to Reports

• Relation between Datasets to Reports

• Relation between Datasets to Dashboards

• Page to Report – Mapping Options

• Publish Options and Data Import Options

• Need for PINS @ Visuals and PINS @ Reports

• Need for Data Streams and Cloud Integration

Power BI Cloud Operations

• Report Publish Options and Verifications

• Working with Power BI Cloud Interface & Options

• Navigation Paths with “My Workspace” Screens

• FILE, VIEW, EDIT REPORTS, ACCESS, DRILLDOWN

• Saving Reports into pdf, pptx, etc. Report Embed

• Report Rendering and EDIT, SAVE, Print Options

• Report PIN and individual Visual PIN Options

• Create and Use Dashboards. Menu Options

• Goto Dashboard and Goto LIVE Page Options

• Operations on Pinned Reports and Visuals

• TITLE, MEDIA, USAGE METRICS & FAVOURITES

• SUBSCRIPTION Options and Reports with Mobile View

• Options with Report Page : Print and Subscribe

• Report Actions: USAGE METRICS, ANALYSE IN EXCEL

• Report Actions: RELATED ITEMS, RENAME, DELETE

• Dashboard Actions: METRICS, RELATED ITEMS

• Dashboard Actions: SETTINGS FOR Q & A, DELETE

• PIN Actions: METRICS, SHARE, RELATED ITEMS

• PIN Actions: SETTINGS FOR Q & A, DELETE

• EDIT DASHBOARD (CLOUD), On-The-Fly Reports

• Dataset Actions: CREATE REPORT, REFRESH

• SCHEDULED REFRESH & RELATED ITEMS

• Dashboard Integration with Apps in Power BI

Improving Power BI Reports

• Publish PowerBI Report Templates

• Import and Export Options with Power BI

• Dataset Navigations and Report Navigations

• Quick Navigation Options with “My Workspace”

• Dashboards, Workbooks, Reports, Datasets

• Working with MY WORK SPACE group

• Installing the Power BI Personal Gateway

• Automatic Refresh – Possible Issues

• Adding images to the dashboards

• Reading & Editing Power BI Views

• Power BI Templates (pbit)- Creation, Usage

• Managing report in Power BI Services

• PowerBI Gateway – Download and Installation

• Personal and Enterprise Gateway Features

• PowerBI Settings : Dataset – Gateway Integration

• Configuring Dataset for Manual Refresh of Data

• Configuring Automatic Refresh and Schedules

• Workbooks and Alerts with Power BI

• Dataset Actions and Refresh Settings with Gateway

• Using natural Language Q&A to data – Cortana

Insights And Subscriptions

• Data Navigation Paths and Data Splits

• Getting data from existing systems

• Data Refresh and LIVE Connections

• pbit and pbix : differences. Usage Options

• Quick Insights For Power BI Reports

• Quick Insights For PowerBI Dashboards

• Generating Insights with Cloud Datasets

• Generating Reports with Cloud Datasets

• Using relational databases on-premises

• Using relational databases in the cloud

• Consuming a service content pack

• Creating a custom data set from a service

• Creating a content pack for your organization

• Consuming an organizational content pack

• Updating an organizational content pack

• Adding Tiles : Images, Videos, DataStreams

• Creating New Reports from Cortana, Advantages

Power BI Integration Elements

• SSRS Integration with Power BI

• SSRS Report Portal URL to Power BI Cloud

• Power BI KPI Reports Vs SSRS KPI Reports

• Converging and Working with Mobile Reports

• Report Builder Reports to Power BI

• Generating QR Codes and Report Security

• Reporting JSON Files, Bulk Data Loads

• Creating high-density Reports in Power BI

• OLAP Data Sources in Power BI

• Using MDX Queries with PowerBI Queries

• MDX SELECT and Perspective Access

• KPIs and MDX Expressions with Power BI

• MDX Queries and Filters with Power BI

• Linked Servers and T-SQL SPROCs with MDX

• YTD, PARALLELPERIOD,SCOPE, ALLMEMBERS

• WHERE, EXCEPT, RANGE, NONEMPTY

• CURRENT & EMPTY, AND / OR, LEFT / RIGHT

• Implementing Row Level Security (RLS)

• Security Roles and Role Members. Tests

• Using R for Power BI, Streaming Data Sets

• Azure Connections with PowerBI Desktop

• PowerBI Reports using SQL Azure DBs

• Short Stories / Case Studies based on real industry experience and research – The correct methods for improvement and dealing with difficult situations is essential to mastering agile scrum. My experience in industry and research into the topic has been used to give you a solid grounding in the most concise way possible.

• Expert Knowledge – I give you a complete overview of how I dealt with difficult situations on the job and techniques used in the business work place without having to do a face to face course saving you hundreds if not thousands of dollars.

• Concise overview of agile scrum – Including the way that the scrum framework is used to deliver projects in industry.

Quizzes
Mock Interviews