Development, Gaming, and Hacking
Brought to you by:
Matrix Tools
(6 / 62 Articles)
View Categories

Power BI


Category
Digital Marketing
Sub Category
Best Free Business Tools
Last Updated
9/14/2020

Intro to Power Business Intelligence

Definitions: Power Platform

  • "Business Intelligence" comprises the strategies and technologies used by enterprises for the data analysis of business information. BI technologies provide historical, current, and predictive views of business operations.
    • Structured
    • ETL (Extract, Transform, Load
    • Database / Data warehouse / Data lake
  • "Data Analysis" is an approach to data that seeks to find insights and indentify patters or trends (Nuggets of Insight).
  • "Data Mining" = Analyzing large amounts of data.
  • "Big Data" = High-volume, unstructured, real-world generated data.
    • Volume
    • Variety
    • Velocity
    • Variability
    • Veracity (How reliable?)

5 Stages of BI

  1. Collect and store data
  2. Transform "Big" data into "BI" data
  3. Present Key Metrics
  4. Evaluate data to discover patterns, trends, and insights
  5. Sharing reports and findings to empower others (Visualizations and Presentations)

Pricing

  1. Free (just hit X on logins)
  2. $9.99/month/person for sharing
  3. Enterprise Level

Row-Level Security

  1. Need a subscription (because it's useless without sharing)
  2. Service Admin

Import Apps

  • Mailchimp
  • Twilio (SMS)
  • Marketo
  • Insightly

Data Analysis Expressions

  • Related
  • Switch
  • SelectedValue
  • IsBlank
  • and &&
  • concat &

Power BI Data Analysis Expressions
Power BI Dax Relationships
(RELATE is Based off Model) Power BI Drag and Drop Relationships
Power BI Dax Switch

Direct Connectivity

  • [clustername].azurehdinsight.net
  • Power Platform

Importing Data

  • Manual Refresh
  • Schedule Refresh
  • Direct Query (never stale)

Direct Query

  • Instead of Importing data into the file, you are connected to a Data Source.
  • File -> Options -> Data source settings (also in Transform data dropdown)
  • Get Data -> Azure Sql Database
  • Options for Authentication (not available on Importing data)
  • Creates a Composite Model based on the link to the data (keeps relationships)
  • Never goes stale because it updates as you click
  • However you do have some control over this if performance on the Database is an issue
  • File -> Options -> Options -> Current File -> Query Reduction
  • On-prem (non-cloud) data sources require a Gateway (Power Bi -> Download -> Data Gateway)

Visuals / Report Builder
Power BI Cards
Power BI Tables
Power BI Maps
Power BI Filled Map
Power BI Tree Map

Natural Query Language
Power BI QNA
Power BI QNA NQL as Map

Data
Power BI Data Tab
Power BI Get Data
Power BI Service Settings
Power BI Embed Options

Conditional Formatting
Power BI Condidtional Formatting
Power BI Dynamic Title

Marketplace / Gallery / Links


Permanent Link
If this article helped you, or you have any thoughts on how to do this better, please click the Like button and/or leave a comment below.

Likes: [1]

Comments: [0]






(if you'd like us to reply and/or show your gravatar image)

Mobile Apps


Category
Digital Marketing
Sub Category
Best Free Business Tools
Last Updated
9/12/2020

COMING SOON! Hit the Heart Button if you want me to finish this blog next!


-- screen shot of phone - business apps - server monitor - apps - ifttt?


Permanent Link
If this article helped you, or you have any thoughts on how to do this better, please click the Like button and/or leave a comment below.

Likes: [0]

Comments: [0]






(if you'd like us to reply and/or show your gravatar image)

Bitrix


Category
Digital Marketing
Sub Category
Best Free Business Tools
Last Updated
9/8/2020

COMING SOON! Hit the Heart Button if you want me to finish this blog next!


super best tool: Bitrix -- crm funnels - company tracking -- online store (how to setup free e-commerce?) -- employee org chart


Permanent Link
If this article helped you, or you have any thoughts on how to do this better, please click the Like button and/or leave a comment below.

Likes: [0]

Comments: [0]






(if you'd like us to reply and/or show your gravatar image)

SEMrush


Category
Digital Marketing
Sub Category
Best Free Business Tools
Last Updated
9/7/2020

COMING SOON! Hit the Heart Button if you want me to finish this blog next!


super best tool: SEMrush all the screens you can get for free. -- how to setup a "campaign" -- real life examples on what we find on our sites


Permanent Link
If this article helped you, or you have any thoughts on how to do this better, please click the Like button and/or leave a comment below.

Likes: [0]

Comments: [0]






(if you'd like us to reply and/or show your gravatar image)

Slack


Category
Digital Marketing
Sub Category
Best Free Business Tools
Last Updated
9/6/2020

COMING SOON! Hit the Heart Button if you want me to finish this blog next!


-- all the slack channels that we use and for what? -- slack C# code integration webhooks -- #bots github / azure -- #alerts errors / downtime -- IFTTT/Zapier -- our 10 app integrations


Permanent Link
If this article helped you, or you have any thoughts on how to do this better, please click the Like button and/or leave a comment below.

Likes: [0]

Comments: [0]






(if you'd like us to reply and/or show your gravatar image)

The Best Tools for Small Businesses


Best Small Business Systems



What Slack integrations do you use?

What websites do you use to run your business?


Permanent Link
If this article helped you, or you have any thoughts on how to do this better, please click the Like button and/or leave a comment below.

Likes: [0]

Comments: [0]






(if you'd like us to reply and/or show your gravatar image)