Skip to main content
Loading Explore guides…
Introduction to power bi · Acedra
Home
Explore
Computer Science
Introduction to power bi
Sign in to save
Chat
If YouTube asks you to sign in, open the video on YouTube.
Watch on YouTube
Reload player
Transcript
90 segments
Copy
Hide video
2:58
>> I'M MARK AND I WORK ON THIS WEBSITE WITH MY PARTNER SETH BOWER. TH THAT'S>> THAT'S ALL>> MY BACKGROUND IS MECHANICAL ENG ENGINEERING. THIS WAS MY DEGREE BACK IN COLLEGE. TOOK A BUNCH OF ENGINEER ING WORK FOR A FORTUNE 500 GUY. DATA IS MY THING. I LIKE NUMBERS AND MATH. WENT ON TO GET MY MBA NOW W WORKING ON MY MASTERS AND DATA SCIENCE I'M SUPER NERD WHEN IT COMES TO DATA E THINGS. WORKING WITH POWER BI STARTED WITH E SELL. THAT WAS MY -- I WAS THE
3:38
GUY THAT WAS LOOK ING -- CAUSING PROBLEMS FOR IT BECAUSE I WAS >> I WAS A SUPER BIG FAN OF THAT. THAT BROUGHT ME INTO POWER VIEW WHICH WAS ORIGINALLY INSIDE EXCEL. AND THEN FROM THERE THEY MIG MIGRATED THE TOOL OUT AND SAID, FORGET THAT WE WILL BUILD OUR OWN TOOLS. AND -- I'VE BEEN AROUND SINCE THE TOOL BEGAN AND I LIKE IT AND IT'S THE IMPROVEMENTS. IF YOU GUYS COULD HAVE SEEN IS EARLY VERSIONS OF THIS. THEY SHOWED A PICTURE OF IT. >> IT ALMOST LOOKS LIKE IT DOES NOW.
4:33
>> THERE'S MORE FUNCTIONALITY ON IT. A THAT'S ME IN A NUTSHELL. SO>> SO THE NICE THING WITH WIDE ROOMS LIKE THIS AND TWO PEOPLE IS WE CAN STAND ON EITHER SIDE OF THE STAGE AND TALK TO YOU AND HIM. MY NAME IS SETH. I WORK FOR A COMPANY CALLED SIDIGO A PRODUCT CONTENT MANAGEMENT TOOL THAT CURE RATES AND GRABS A BUNCH OF DATA. HELPS SUPPLIER CLEAN, CLEANSE AND SEND [ INDISCERNIBLE ] TO OUR RECIPIENTS. AND MY PASSION IS POWER BI AND POWER BI COMMUNITY.
5:11
WHEN I'M NOT IN MY DAY JOB ESSENTIALLY WORK WITH MIKE AND WE CURE RATE A BUNCH OF CONTENT TO TRY TO HELP BUSINESS USER GET THE MOST OUT OF THE TOOL. I'M A COMMUNITY SUPER USE EHER I ANSWER LOT OF QUESTIONS ON THE COMMUNITY FORUMS. THAT'S WHERE I GOT MY START. I WAS AROUND FROM THE BEGINNING AND LATCHED ON TO THE COMMUNITY AND THAT'S WHERE MY INITIAL QA AROUND THE SERVICE AND THAT TYPE OF THING HAPPENS. WE ALSO CO-LEAD OUR LOCAL COMMUNITY POWER BI USER GROUP. IF YOU'RE NOT
5:48
FAMILIAR DYNAMIC COMMUNITIES IS THE ORGANIZATION THAT RUNS THE USER GROUPS. YOU CAN FIND POWER BI USER GROUPS ACROSS THE GLOBE. WE HIGHLY RAIMENT RECOMMEND YOU JOIN SO WE HIGHLY RECOMMEND DOING THAT AS WELL. >> ANYBODY FROM THE MILWAUKEE USER GROUP? WE GOT ONE OF THEM. I KNEW HE WAS HERE. THANK YOU FOR COMING ALL THE WAY HERE FROM MILWAUKEE. WE APPRECIATE IT. >> IF YOU LIKE MIKE CAMPI 99 OF THE TWEETS DO ON TWITTER IS SHARING POWER BI THE LATEST AND GREATEST BLOGS WE FIND.
6:33
OTHERWISE OUR LINKED IN PROFILES ARE UP THERE AS WELL. DUE TO OUR COMMUNITY SERVICE WE ARE BLESSED TO HAVE BEEN GIVEN THE MICROSOFT MVP AWARD THAT OPENED THE GREAT RELATIONSHIPS WITH THE OTHER PEOPLE THAT ARE PASSIONATE ABOUT TOOLS AS WE ARE AND GIVES OPPORTUNIT IES TO SHARE WHAT WE LOVE DOING WITH YOU . OPINION THANK YOU FOR JOINING US. >> PASSIONATE, MAYBE CRAZY. FIRST OFF, WE'RE GOING TO TALK THROUGH THE BEST PRACTICES OR THINGS WE FIND THAT YOU CAN DO IN YOUR REPORTS
7:08
TO MAKE THEM MORE EFFECTIVE WITH YOUR END USERS AND DIVE INTO A LITTLE MORE DEMO AND ADVANCED TOPICS. ABOUT 10 YEARS AGO A GENTLEMAN BY THE NAME OF SIMON SNIK YOU MAY BE FAMILIAR WITH HIS TED TALK. HE TALKS ABOUT BUSINESSES AND HOW THEY MARKET THEIR PRODUCTS TO PEOPLE AND CAME UP WITH THIS GOLDEN CIRCLE THEORY PRINCIPLE RECENTLY I HAD SEEN SOMEBODY TALKING ABOUT IT AGAIN. THERE WERE A LOT OF CORRELATIONS THAT ALSO WE STARTED TO TIE TOGETHER WITH HOW WE APPROACH
7:44
REPORT BUILDING. REPORT AUTHORS AND WHAT PEOPLE ARE REQUESTING FROM US AND WHAT WE GIVE BACK. ON THE OUTSIDE OF THE CIRCLES THERE'S THE WHAT? WHAT ARE THEY ASKING FOR? RIGHT UNDERNEATH THAT HOW. IT'S THE DEVELOPMENT. TAKING THE REQUIREMENTS AND YOU'RE CAN HE BEING TO THOSE DATA SOURCES. GIVING IT BACK TO THEM IN THE REQUESTED FORM. HOW OFTEN ARE WE TALKING ABOUT THE WHY? WHAT IS THE WHY? THE WHY IS WHY ARE THEY ASKING WHAT THEY ARE? WHY DO THEY WANT TO SEE THAT DATA. WHAT
8:18
ARE THEY GOING IT THAT IS CHANGING OR HELPING THEM SHAPE DECISIONS THAT THEY'RE WITHIN THEIR BUSINESS. ULTIMATELY IS HAPPENING -- GIVE ME THIS REPORT. THIS CAN COME FROM THE END USERS THEMSELVES BUT MORE THAN NOT DEPENDING ON WHO IS BUILDING THE REPORT IT'S THROUGH THE PROGRAM OR THE PROJECT MANAGER, A COUPLE FILTERS, AND YOU GET THE SET OF REQUIREMENTS THAT LAND ON YOUR DESK AND WHAT DO YOU DO? YOU START LOOKING AT THE REQUIREMENTS, FIGURING OUT HOW YOU DEVELOP AGAINST THAT AND
8:53
HOW YOU RETURN THAT. SERVICES OR POWER BI OR ANOTHER TOOL. WHY YOU WOULD JUSE SOME OTHER TOOL. >> I DON'T KNOW WHY I WYOU WOULD USE ANOTHER TOOL. WHAT I WOULD SUGGEST IS WE TAKE A STEP BACK AND REEH EVALUATE HOW WE ARE CONSUMING THOSE REAQUIREMENTS AND START WITH THE WHY. THE WHY IS A SOERIES OF QUESTIONS THAT I WANT TO TALK TO THE END USER ABOUT. I WANT TO KNOW WHY THEY WANT TO SEE THIS DATA. WHAT ARE THEY TRYING TO ANSWER AND THAT'S WHAT I WANT TO SOLVE WITH MY REPORTS.
9:30
THERE'S A GRAND SPECTRUM OF THINGS. ANALYST, THEY -- THEIR WHY MIGHT BE A PART OF THE ORGANIZATION. IF IT'S AN EXECUTIVE THEY WANT TO SEE PARTICULAR KPIS OR NUMBERS THEY CAN AT A GLANCE FIGURE OUT WHAT THEIR DECISION IS GOING TO BE. BUT IT'S OUR JOB TO FIGURE OUT THE WHY WRATH E THAN JUST -- RATHER THAN BLINDLY FILL OUT REQUIREMENTS OR REPORTS. A LOT OF TIME IS WASTED IN BETWEEN THESE STEPS AND WE'RE MISSING OUT ON THE REAL REASON WE'RE BUILDING REPORTS ALL THE TIME, WHICH
10:05
IS TO SOLVE THE BUSINESS PROBLEMS. SO I WOULD SAY, IF YOU'RE -- IF YOU DON'T UNDERSTAND THE QUESTIONS THAT THEY'RE TRYING TO ANSWER, START THERE. A GREAT USE CASE OR EXAMPLE, I JUST JOINED THIS COMPANY NOT LONG AGO. I GOT THIS REQUIREMENTS LIST. IT WAS SOMETHING IN MY YEARS THAT I'VE LEARNED THAT I DIDN'T WANT TO JUST SPIT OUT A SPREAD SHEET, ESPECIALLY NOT OUT OF POWER BI. I GOT IN FRONT OF THE END USER AND STARTED TO LISTEN THROUGH CONVERSATION
10:35
OF LIKE, WHAT WERE THE THINGS TRYING TO SOLVE. AND WITHIN THIS CONVERSATION THERE'S PEPPERED LITTLE THINGS. I'M GETTING DOWNWARD PRESSURE FROM THE ORGANIZATION. I'M FEELING LIKE I -- I DON'T KNOW ABOUT THIS PARTICULAR THING. WHEN I USE THE PRODUCT THIS IS MY STRUGGLE. IN BETWEEN THERE WAS, THAT'S WHY I NEED TO SEE THIS, THIS, THIS AND IF YOU GIVE ME THIS, I CAN ADD THAT. A LOT OF THE PEOPLE ON THEED -- ON THE CALL, EVERYBODY TRYING TO HELP WERE SAYING, CAN
11:05
I DO THAT, ABC DID HE RECOLLECTS F. -- ABCDEF. I DERAILED EVERYTHING AFTER THE CASE WHEN AT THE END WE HAVE A SEPARATE CALL AND ADDRESS THESE PROBLEMS. RIGHT? THEN YOU CAN SHAPE THE RIGHT REPORT FOR THEM. IT'S A GREAT STARTING POINT FOR DRIVING TOWARDS THE BEST REPORT. >> I WANT TO JUMP IN. THINKING THROUGH, IF YOU THINK ABOUT YOUR NORMAL WORK FLOW, HOW MANY PEOPLE WOULD SAY THEY'RE FROM THE BUSINESS SIDE OF THINGS>> RUN THE BUSINESS. OKAY. YOU GUY ARE MY EXCEL LOVERS. YOU
11:49
LOVE EXCEL? >> GOOD. IN MY WORLD, THE BUSINESS SIDE, WE ALL DEAL WITH IT. HOW OF THE SEASON A USER ASKING FOR A REPORT FROM THE IT GROUP AND THEN JUST SHOW ME THE EXPORT TO EXCEL BUTTON. I'M GETTING THIS DATA TOGETHER AND WHATEVER IS THERE IS USUALLY A TABLE OF SOME FORM, THEY EXPORT TO EXCEL, I HAVE A SERIES OF WORK FLOW WHERE IS I TAKE THE DATA OUT. I'M GOING TO COPY IT, PASTE IT, PUT IT IN SOMETHING ELSE. ADD MORE DATA. SMUSH IT TOGETHER AND OUT PUTS MY ANSWER. A LOT OF
12:21
TIMES, ASKING THE WHY QUESTION GETS YOU INTO, YOU KNOW, WHAT ARE THE ACTIONS I NEED TO TAKE FROM THE DATA. THAT'S DIFFERENT THAN I NEED THE TABLE OF THESE COLUMNS. WHAT AM I ACTUALLY LOOK RE FOR? THESE ARE QUESTIONS THAT YOU WANT TO ASK IS WHAT ACTION DO YOU WANT THE TAKE TO DELIVER SOMETHING AND THOSE ARE THE POINTS WHERE YOU CAN NREN AND SAY, I NEED TO KNOW WHAT MY TOTAL SALES IS. WHEN WE'RE DECLINE INCLINING I NEED TO TURN IT AROUND. I NEED A DECISION POINT THE SAY WHEN I'M
12:54
GOING TO ADD MORE PROMOTIONS. SO WE TALK IN THOSE TERMS AND ASK, WHAT IS THE ACTION I WANT TO DRIVE WITH THIS REPORT? WE CAN START WALKING PEOPLE AWAY FROM THE TABLES OF DATA THAT CONTINUALLY EXPORTING AND CONSTANTLY CHURNING AND PROVIDE VISUALS THAT PROVIDE IMPACT. >> DIALLING BACK INTO REAL VISUAL VISUALIZATION. SO WHEN PREPARING FOR THIS SESSION I WAS WONDERING WHETHER THIS IS A GROSS EXAMPLE OF AWAY YOU DO AND DON'T DO. I COUNSEL BECAUSE EVERY TIME I INTERACT WITH A HEAVY IT
13:35
PERSON AND IT'S USUALLY LIKE IN NET NETWORKING OR THE HARDWARE I ALWAYS ONE, SEE A PIE CHART. AND I LIKE TO WATCH HOW I DESCRIBE THIS AS, I LIKE TO WATCH HOW MANY DESERTS I CONSUME SO I DON'T REAL USE PIE CHARTS OR DONUT CHARTS. THAT'S NICE WAY OF SAYING I THINK I DON'T LIKE THEM. REAL ESISTICALLY HEREFY WANT TO LOOK AT ACCOUNT OF SOMETHING, THERE'S TWO WAYS IN WHICH YOU CAN DO THAT. ONE IS A REALLY CHALLENGING WAY FROM A VISUAL STANDPOINT OR A SIMPLE WAY. ONE OF THE THINGS
14:14
WE CAN CHALLENGE OR RECOMMEND, EVEN MANY THE DEFAULT SETTINGS OF THE VISUALIZATIONS THAT YOU CREATE WITHIN POWER BI MORE OFTEN THAN NOT THERE ARE A LOT OF THINGS ON THAT VISUAL THAT YOU REALLY DON'T NEED. SO IN THIS CASE DO I NEED AN X- X-AXIS? >> IT'S EASIER FOR ME TO CLICK AND PUT ON A DATA LABEL INSTEAD OF THAT X-AXIS. I CAN SIMPLIFY THINGS THE MORE COMPLEX THOSE VISUALS GET AND BECAUSE I HAVE INTER ACTION BETWEEN MULTIPLE DIFFERENT VISUALS ON A
14:48
PAGE. SOMETIMES CAN I PLAY OFF THE VISUALS TO GIVE THE INFORMATION I NEED. OUR GOAL HERE IS TO BE AS CLEAR AS POSSIBLE WITH THE END USER AND HELP THEM CONSUME THINGS AS OFFICIALLY AS POSSIBLE AS WELL. NOW THERE'S A TON OF THEORY BEHIND THIS. COLOR THEORY, GROUPING, THINGS LIKE THAT THAT ARE ALL BEHIND REASONS WHY WE'RE RECOMMENDING DOING TYPES OF THINGS LIKE THIS. ULTIMATELY WE ARE VISUAL LEA LEARNERS. WE AS REPORT CREATORS, THE MORE SEISM SIMPLIFY WE CAN CONVEY A MESSAGE,
15:22
THE FASTER PEOPLE CAN CONSUME OUR REPORT. AS OPPOSED TO IF I HAVE CHALLENGING VISUALS OR NOT AS CLEAR IN MY MESSAGE WHAT ENDS UP HAPPENING IS PEOPLE HAVE TO THINK MORE ABOUT WHAT THEY'RE LOOKING AT BEFORE THEY CAN COME TO THE CHOICE THAT THEY NEED WITHIN YOUR REPORT. IF I MINIMIZE THE AMOUNT OF TIME IT TAKES FOR SOMEBODY TO DIGEST THAT INFORMATION I'M MORE EFFECTIVENY -- IN MY REPORT OFF OFFERING. ANOTHER EXAMPLE IS SOMETHING WE SEE QUITE A BIT. IF A -- IF I CAN GET YOU TO FOCUS ON
16:02
THE TOP TWO VISUALS AND THEN THE BOMB BOTTOM TWO. YOU'LL SEE IT'S THE COUNTER REGION BY REGION. USING THE DEFAULT TITLES, I DIDN'T DO ANYTHING TO CHANGE THOSE. AS I WOULD INTERACT WITH THE REPORT, I MIGHT WANT TO CLICK ON MY SOUTH REGION. THE OTHER FILTERS, I CLICK ON THE -- REGIONS. ANYBODY RECOGNIZE WHAT'S HAPP HAPPENING? >> THE LENGTHEDS ARE DIFFERENT. >> COLORS ARE WRONG. THIS IS AN OVER SIMPLIFIED WAY. SO OFTEN WE ENCOUNTER REPORTS WHERE THERE'S FOUR, FIVE, SIX DIFFERENT
16:45
VISUALS ON A PAGE AND EVERY SINGLE ONE CAN HAS A DIFFERENT LEGEND BUT THE SAME CO COLORS. IT IT MAKES ME THINK ABOUT WHAT IS HAPPENING WITHIN, NOT JUST THE BARS OR PIE GRAPHS OR WHATEVER, I NOW HAVE TO FIGURE OUT WHICH LEGEND I'M LOOKING AT. DOES THAT CORRELATE WITH A DIFFERENT LEGEND. YOU SEE WHERE THIS STARTS TO SPIRAL OUT OF CONTROL. ONE THING WHEN YOU'RE USING DIFFERENT VISUALIZATIONS AND LEGENDS IS TO SIMPLIFY OR KEEP CONSISTENT IN TERMS OF COLOR ACROSS
17:25
THE VISUALIZATIONS. SO IN THE BOTTOM OR LOWER END AREA, ONE OF THE THINGS WE LOVE DOING IS RATHER THAN HAVING TO FILTER OR A SLICER, WHAT WE DO OR LEGEND. IS WE TAKE THAT AND USE A ST STACKED COLUMN CHART. WE USE THE REGION AS THE VALUE AS WELL AS, I'M SORRY, THE ACCESS AS WELL AS THE LEGEND AND WE HAVE SOMETHING WHERE I MY SOUTH REGIONVY THE COUNT OF IT. AND WHENEVER I CLICK THAT, THAT'S MY TLA-- TLAEJD WILL IMPACT THE VISUALS IN THE REPORT PAGE NOW
18:01
I HAVE CONSISTENCY IN DRCOLOR. IT'S EASY TO UNDERSTAND THE DIFFERENT ASPECTS OF THE DIFFERENT VISUALIZATIONS AS I'M CLICKING THROUGH AND CREATING THAT CONSISTENT EXPERIENCE ON THE REPORT PAGE. MAKE SENSE? >> THIS IS A MY NEWT DETAIL IT'S A BIG -- MINUTE DETAIL BUT A BILL WIG IMPACT. >> ANOTHER IS SPACE. IN THE PREVIOUS VISUAL, THE TOP ONE IS AN EXAMPLE. THE BOTTOM IS THE EXAMPLE OF THE RIGHT WAY. EVEN HE LIST STICKICALLY AS WE -- HOLISTICALLY IT BECOMES
18:40
APPARENT QUICKLY WHERE YOUR EYES GO AND WHAT'S WRONG BECAUSE SOMETHING DOESN'T ALIGN. ONCE AGAIN, I WOULD LOVE TO SAY THAT THIS IS JUST AN ANOMALY. WE SEE SO MANY DIFFERENT REPORTS WHERE ONE, PEOPLE WANT THAT A ADDED LITTLE SNAP OF PIZZAZZ. SO THEY ADD A BORDER THAT IS BLACK LINE AROUND EVERYTHING. THAT ENHANCES INACCURACY. IF YOU DON'T HAVE THE REPORT VISUALS PERFECTLY ALIGNED IN THE WAY THAT DOESN'T DISTRACT YOU FROM WHAT THE REST OF THE REPORT IS TRYING TO DO WHICH IS CONVEY
19:14
THE INFORMATION. THE NICE ANYTHING POWER BI IS, THEY -- WE HAVE A TON OF ABILITY TO MODIFY AND CHANNEL THESE THINGS RIGHT AWAY. UNDER FORMATTING WE CAN ALIGN TO THE TOP AND DISTRIBUTE HORIZ HORIZONTALLY. TO MAKE THAT AN EASY EXPERIENCE. WITH THE NEW GRID LINES THERE'S LESS OF A REASON FOR THESE ANOMALIES TO HAPPEN WITHIN YOUR REPORT. SO WITH THE NEW GRID LICENSE JUST LIKE POWER POINT THOSE SHOW UP AS RED LINES AND THEY KIND OF SNAP ALL OF YOUR OBJECTS TOG
19:55
TOGETHER. NOT QUITE LIKE THE GRID EXPERIENCE YOU CAN ENABLE BEHIND THE SCENES. LITTLE LITTLE NUDGES TO MAKE ALL OF YOUR VISUALS THE RIGHT SIZE OR ALIGNED APPROPRIATELY. >> ANOTHER TIP OR TRICK WE USE A LOT BECAUSE WE DO A LOT OF BU BUILDING OF THESE THINGS, GET ONE -- WE HAVE A THREE CARDS IN THE TITLE OF THIS THING. APP LOT OF TIMES YOU USE THE SAME VISUAL MULTIPLE TIMES. PARTICULARLY IN A SINGLE DATA POINT. TRY TO GET ONE OF THEM DONE COR CORRECTLY. ALL THE THINGS YOU NEED
20:27
SHAPED RIGHT. THE COLOR IS RIGHT, TITLE IS RI RIGHT. MAKE THE ONE AND COPY IT MULTIPLE TIMES. YOU SET YOUR PROPERTIES ONCE AND IT'S A BIG TIME SAVER. A LOT OF TIMES I NEED THREE CARDS AND THREE CARDS COME OUT AND THEY SPOKENED MUCH TIME MAKING SURE THE FORMATTING IS ALIGNED BETWEEN ALL OF THEM. ANOTHER TIP, IN THE HOPE RIBBON ON THE LEFT HAND SIDE THERE'S A FORMAT PAINTER. YOU CAN GRAB A VISUAL AND SELECTED VISUAL AND PAINT THAT FORMAT ON OTHER VISUALS. ALSO VERY
21:01
HELPFUL AS WELL. T TAKING A STEP BACK TO, WHAT ARE SOME TIME SAVING TECHNIQUES THAT WE CAN DO VISUALLY IN OUR RE REPORTS TO CREATE CONSISTENCY NOT JUST WITHIN THE REPORT BUT ALL REPORT PCHGS -- REPORTS. STHEEMS A FANTASTIC WAY TO DO THAT SHOW OF HANDS HOW MANY PEOPLE USE THEMES ON A REGULAR BA BASIS? HAVE USED THEM? OKAY. WE'LL GO THROUGH AN EXAMPLE QU QUICKLY. BUT FOR THE REST OF YOU THEMES ARE AN AREA UP IN THE TOP HEADER BAR WHERE YOU CAN SWITCH A THEME AND BY DEFAULT
21:39
WE'LL SEE A DROP DOWN. THERE ARE ABOUT OUGHT DIFFERENT TYPES OF THEMES THAT YOU CAN AUTOMATICALLY APPLY TO YOUR REPORT. SO AS I CLICK ON SAY ELECTRIC YOU SEE THE BACKGROUND HEADER CHANGES AND THE REPORT ON THE REA RIGHT-HAND SIDE CHANGES. THE OTHER REPORT, NEXT TO IT, DID NOT CHANGE. THE REASON FOR THAT IS A LITTLE THING TO BE AWARE OF WHEN USING TH THEMES. . IF YOU SET COULD USTOM COLORS OR BRING YOUR OWN HEX CODES. TO THE POWER BI. IF I'M CLICKING ON THAT PARTICULAR
22:19
VISUAL ON MY FORMAT PAINTER, GO TO DATA COLORS I CLICK ON A PARTICULAR COLOR. IF I SELECT THE CUSTOM COLOR I CAN ADD IN A HEX CODE. IF I DO THORAX I'M DISABLING -- IF I DO THAT, I'M DISABLING THE VISUAL FROM BEING UPLOADED BY ANY EXTERNAL THEME. IF I STICK WITH THE DEFAULTS, IF I JUST COPY THIS VISUAL AND I SAY, GIVE ME THE LIGHT VERSIONS OF BLUE, PURPLE, THIS PINK. AND ORANGE. NEXT TIME I CHANGE THE THEME, THOSE WILL CHANGE ALONG WITH IT. WHAT THEY'RE
23:01
DOING IS TAKING THE TOP LEVEL COLORS THAT WE CAN IM IMPORT VIA A THEME AND MAKING DIFFERENT GRADE YENTAS OF THAT UNDERNEATH WHERE WE SEE THIS A LOT WHERE THE THEME DOESN'T AP APPLY. I HAVE PARTICULAR BRANDING WHICH IS ALSO WHY YOU'RE PROBABLY CREATING A THEME. THAT YOU USE THOSE PARTICULAR HEX COLORS OR WITHIN YOUR VISUALIZATIONS AND WHEN YOU TRY TO APPLY A THEME AFTER THE FACT, IT DOESN'T WORK. TO ANSWER THE QUESTION I HAVE THESE DEFAULT THEMES. WHAT
23:38
IF THEY DON'T USE MY OWN BR BRANDING? WE CAN IMPORT OUR OWN THEME. LET ME SHOW YOU WHAT THAT LOOKS LIKE. A THEME THAT WE'RE IMPORTING IS ACTUALLY A JSON FILE. SO IT'S A JAVA SCRIPT OBJECT NOTATION FILE. ESSENTIALLY IT'S A CODING WAY THAT'S EASILY READABLE FOR US TO UNDERSTAND. SO WITHOUT GIVE ING HEAVY INTO IT, THE PARTICULAR THEME WE'RE L LOOKING AT IS A LIST OF HEX CO COLORS. AND A BACKGROUND APPLIED. THIS IS WAY DEEP. IF YOU WANT TO BUILD YOUR OWN THEMES THERE'S A GREAT GITHUB
24:24
RESUPP RESUPPOSITORY. THERE'S A SCHEMA THAT MICROSOFT PROVIDES ON THEIR TECHNICAL DOCUMENTATION NUDGE YOU CAN GET THIS THE WEEDS WITH THIS AND CREATE HIGHLY CUSTOMIZED THEMES YOU CAN IMPORT. THE VALUE IS THAT YOU'RE SP SPENDING ONE TIME TO DO THAT EXERCISE, AND APPLY THAT SAME THING TO ALL CRYOUR REPORTS IN THE SAME WAY. SO ABOVE AND BEYOND COLORS. THEMES CAN IMPACT MULTIPLE OR ALL THE PROPERTIES ON A VISUAL VISUALIZATION. FONT COLORS , FONT SIZE, ET CE CETERA. WHAT IF, I DON'T
25:00
WANT TO CREATE MY OWN THEME. BUT I WANT TO IMPORT MY OWN TH THEME. WHAT DO I DO? THERE'S ONE TOOL THAT LET'S YOU OR HELPS YOU OUT WITH THAT. YOU DON'T HAVE THINGS SET UP THE WAY I DO. SAY YOU HAVE YOUR HEX CODES. SO I'M GOING TO BRING IN THE BRAND HEX CODES THAT MY MA MARKETING DEPARTMENT HAS GIVEN ME. VY THIS LIST OF HEX CODES THAT I WOULD LOVE TO PUT INTO A THEME, BY DON'T WANT TO MESS AROUND WITH A PARTICULAR JSON FILE. SO WHAT YOU CAN DO IS TAKE THESE THEMES
25:51
JAB THEM AND GO TO A WEBSITE CALLED POWER BI. TIPS. >> YOU'LL SEE A THEME GENERATOR. THERE'S MULTIPLE DIFFERENT VER VERSIONS. YOU CAN PICK CYOUR OWN COLORS THERE'S A WHOLE SLEW OF TABLE VISUALIZATIONS YOU SEE IN POWER BI. YOU'LL SEE ALL THE PROPERTY WITHIN POWER BI ARE HERE AND D DROP DOWNS FOR THE PARTICULAR ALWAYS VALUES THAT CAN BE INSERTED IN TO THOSE. TO HELP BUSINESS USERS GENERATE THEIR OWN THEMES YOU CAN DUMP IN YOUR HEX CODES HERE. ADD THOSE AND SEE THAT
26:30
THESE ARE THE COLORS THAT I WANT TO APPLY AND JUST CLICK DOWNLOAD AND IN A JSON FILE IS DOWNLOADED TO YOUR COMPUTER. >> SWRE A QUESTION. > >> [INAUDIBLE QUESTION] >> THERE'S A SECTION ON THE PAGE. THERE'S ONE EQUALLED CALLED GLOBAL DATA SET COLORS. IT'S ACTUALLY GLOBAL PROPERTIES WE CAN ADJUST. THIS WHOLE SECTION IS DEDICATED TO COLORING THE ENTIRE REPORT. THERE'S A WINDOW AT THE BOTTOM OF THE PAGE ADD BELOW COLUMN SELECTIONS. A TEXT BOX, YOU CAN DUMP IN YOUR HEX CODES. HEX CODES
27:18
SEPARATED BY SPACE OR SEPARATED BY COMMAS. ANY FORMAT YOU PUT IN THERE IT WILL PARSE OUT THE DATA FOR YOU, MAKE A NICE LIST, AND YOU CAN DRAG AND REORDER THE COLORS INSIDE THE DROP WINDOW. SO IF YOU CLICK AND DRAG ONE OF THOSE, IT WILL LET YOU REORDER THENYL THEM INSIDE THE BOX. YOU GET THE COLORS IN THERE AND THAT'S NO THE ORIENTATION YOU WANT THEM, YOU CAN REARRANGE THERE. GREAT QUESTION. >> CLICK DOWNLOAD THAT CREATES THE JSON FILE IN MY DOWNLOADS F FOLDER. I CAN
27:52
CLICK ON IMPORT THEME. IF I GO TO MY DOWNLOADS FOLDER. >> DESKTOP. AN EASY WAY FOR YOU TO GET A LOT OF THAT VALUE. BRING IN YOUR OWN COLORS YOU WANT TO AND THAT'S ONE THING WE'VE DONE ON OUR SIDE. QUESTION? >> [INAUDIBLE QUESTION] >> THE QUESTION WAS IS THERE A WAY TO TIE A PARTICULAR COLOR TO A DIMENSION? THERE'S CONDITIONAL FORMING ON A LOT OF INTERESTING THINGS IN THE TOOL. I'M SURE YOU COULD WRITE SOME DAX TO ALLOW YOU TO DO THAT AND PEG A PARTICULAR
28:43
GROUP. BY DEFAULT THE PROGRAM WILL ALWAYS TRY TO APPLY THE COLORS TO THE SAME ITEMS ACROSS THE ENTIRE REPORT. IF YOU HAVE A COLUMN THAT SAYS CUSTOMER A EVERY RWHERE THAT A --S A LONG AS YOU'RE USING THE SAME COLUMN AGAIN. SET THE COLORS ONCE AND MY RECOMMENDATION IS NOT DO IT B BASED ON CODE. SET THE COLOR PALETTE AND REUSE THE SAME COLUMN OF DATA EVERYWHERE ELSE IN THE REPORT AND IF YOU'RE USING THE SAME COLUMN ON MULTIPLE VISUALS THE COLORS WILL MATCH FOR YOU. >> OTHER QUESTIONS?
29:40
>> [INAUDIBLE QUESTION] >> IF YOUR BRANT CREATED SIMILAR POWER POINT FILE? >> [INAUDIBLE QUESTION] >> SO THIS DOESN'T USE ANYTHING FROM POWER POINT. YOU'LL NEED TO GET THEIR COLOR CO CODES. SO THESE ARE THE HEX COLORS THAT WE'RE USING. THE THINGS WE'LL USE FOR ELEMENTS. WHEN YOU'RE IN THE DESKTOP YOU CAN STYLIZE THINGS HERE. FOR EXAMPLE, TO FILL OUT YOUR QUESTION. IF I'M ON THIS PAGE I CLICK THE PAINT ROLLER. IF I NEED THE HEADER BAR TO BE A CERTAIN COLOR YOU WANT TO PUT THAT
30:12
COLOR THAT NEEDS TO BE HEADERS SOMEWHERE IN THE LIST OF COLORS AND KNOW THE THIRD POSITION IS TYPICALLY MY HEADER BAR. HERE, FY OPEN THIS PAGE BACKGROUND I CAN ADJUST THIS COLOR TO THE SCENT ITEM OF -- SEVENTH ITEM. I CAN SET SPECIFIC POSITIONS THAT BECOME THAT COLOR. SO YOU HAVE TO TAKE THEIR BRAND GUIDELINE AND THINK OF HOW YOU'RE GOING TO MAKE A COLOR PALETTE THAT MATCHES THAT. MAKE SENSE? >> THEY'RE PULLING INS A ASPECTS OF POWER POINT. THERE'S NO COHESION BETWEEN
30:50
THEMES YOU CAN GENERATE THERE Y YET. >> WHEN YOU'RE IN POWER BI THE P BURKES EXX FILE. YOU CAN EXPORT A PBIT FILE WHICH RETAINS THE WORK YOU'VE DONE WITHIN THE CONTEXT OF THE WORK. ESSENTIALLY IT'S A SHELL THAT YOU COULD CREATE FOR BRANDING. YOU COULD CREATE YOUR THEME AS A BRAND REPORT FILE AND THAT'S BASE FOR EVERYBODY WHEN THEY CREATE THE REPORTS FROM THEN ON. IF YOU DO A SAVE-AS ON YOUR FILE DEFAULTS TO PBIX. THAT MEANS IT HAS DATA IN IT. AND OTHER INFORMATION. IF
31:38
YOU SAVE IT AS A PBIT WHICH IS A SAVE-AS DIALOGUE BOX. THIS IS THE TEMPLATE FILE. IF YOU SAVE A MODEL THAT HAS DATA IN IT IN TABLES. IF YOU'RE USING IMPORT MODES IT WILL STORE IN COMPRESSED FORM INSIDE FILED. USING PBIT DOES NOT DO THAT. THE FILE USUALLY BECOMES MORE LIGHTWEIGHT AND THEN YOU HAVE THE ABILITY TO WHEN YOU OPEN THE FILE BACK UP, IF THERE'S A DATA ATTACHED TO IT. YOU'LL NEED TO REFRESH IT BEFORE THE VISUALS DISPLAY THEM. AGAIN, YOU CAN BASICALLY BUILD A PBIT WITHOUT
32:15
DATA ATTACHED TO IT AND DO THE STYLING STUFF BEFOREHAND AND CONTINUALLY OPEN THE PBIT FILES. >> [INAUDIBLE QUESTION] >> CORRECT. >> [INAUDIBLE QUESTION] >> YES. >> [INAUDIBLE QUESTION] >> P BURKES T YOU CAN'T RESAVE AS PBIT. IT STARTS AS A BLANK FILE AND WHEN YOU HIT SAVE IT WILL PROMPT YOU, THIS IS A BRAND NEW FILE I NEED YOU TO PUT A NAME FOR THE FILE AND SAVE IT. THE THEMES AND COLORS AND FONT SIZES ET CETERA THAT YOU APPLY WILL PERTAIN TO NEW AND EXISTING OBJECTS WITHIN YOUR
33:07
FILE. >> WE'RE GOING TO TRANSITION TO OTHER ELEMENTS. HOW MANY PEOPLE HAVE USED BOOK MARKS? GOOD NUMBER. GREAT. HOW MANY USING BOOK MARKS AS KNAVE NAVIGATIONAL ELEMENTS IN THE PAGES. LESS. HOW MANY PEOPLE ARE USING BOOK MARKS TO SHOW AND HIDE THINGS? EVEN LESS OPINION THAT'S WHAT WE EXPECT. THERE'S SOME TECHNIQUES YOU CAN USE WITH PARTS OF THE TOOL THAT ENHANCE THE REPORTING EXPERIENCE. LE >> LET'S SAY THIS IS A SYRUPAL REPORT THAT WE HAVE. I'M GOING TO
33:46
THE DEFAULT THEME. WEAVER COINED THIS TERM -- >> WE BUILT THESE TEMPLATE FILES ESSENTIALLY AND START THINKING THROUGH WHAT ARE GOOD COLOR DESIGNS. WHAT IS GOOD UIUX DESIGN. THIS IS A REPORT YOU MAY HAVE. THEY SEE THE COLORS SEEM TO MATCH. AS IT TRANSLATES ACROSS THE U. S. AND SEE HOW THINGS ARE CHANGING. GOOD START. SOMETIMES YOU'LL GET A REQUEST AND THIS COMES FROM SOMEONE. THAT LOOKS OKAY. I NEED TO HAVE MORE MISS STAS. I'VE DONE A YOU REMEMBER IN OF PROJECTS CAN CUSTOMERS DOIF
34:25
YOU'RE SHARING DATA BETWEEN COMPANIES USING POWER BI SOMETIMES YOU NEED MORE FLAIR IN THE REPORT. >>FY CLICK ON THE PAINT ROLLER YOU WILL SEE AN IMAGE APPLIED HERE. THAT WE PUT ON THE BACK OF THE PAGE. THERE'S AN IMAGE STUCK ON THE BACK OF THE PAGE THIS HAS STUFF LAID OUT ON IT ALREADY. ? IF I CLICKED ON ONE OF THESE YOU WILL SEE IT BRENTS UP. IT HEIGHT LIGHTS AND GOES AWAY. IT GIVES AN INDICATOR. THESE ARE GOOD COMMON BEST UI PRACTICES WHEN YOU'RE DESIGNING THINGS. TRUST ME
35:31
WE SPENT A LOT OF TIME DAYS THINKING THEM THROUGH. GETTING EVERYTHING ALIGNED. IF YOU HAD TO DO THAT FOR EVEEVERY SINGLE PROJECT YOU'RE SPENDING MORE TIME PREPPING THE DOCUMENTATION PIECE. THINK WITH ME FOR A SECOND. I'VE SPENT TWO WEEKS DOING THIS AMAZING DATA MODEL. IT'S OP. WE'RE GETTING THE ANSWER WE WANT. PEOPLE ARE BEING PLEASED AND WE'RE OUT ALM TIME WE NEED TO DELIVER THE LAST PART OF THE LAST THING YOU USUALLY CUT IS SPENDING THE EXTRA TIME AND MAKING THE REPORT POP.
36:02
USUALLY THE END OF THE REPORT THE PART THAT'S PROBABLY, I WOULD SAY VERY IMPORTANT. IT'S GOOD TO VIAE SOLID DATA MODEL. I DON'T WANT TO REPORT SALES THAT ARE INCORRECT. AT THE END OF THE DAY, FY HAVE AN ENGAGE REPORT THAT IS COMPELLING TO LOOK AT, I CAN ENGAGE MY AUD AUDIENCE. THEY'RE READY TO LOOK AT THE REPORT. IF YOU'RE IN THE MARKET AND UPSETTING OR REMOVING OTHER TOOLS THAT YOU'RE REPLACING. IT'S ALSO HELPFUL TO HAVE A GOOD SIGNING REPORT. SO PEOPLE LOOK AT
36:33
IT AND SAY THIS IS AMAZING AND LOVE IT. WE WILL GO FURTHER. WE MAKE A CUSTOM SET OF I CONS. MAKE IT REALLY CLEAR AND BUTTONS TO MAKE IT INTERACTIVE. SO WE'RE GOING TO DO A QUICK DEMO OF THIS. I WILL GRAB THE EXISTINGDATE HAVE HERE AND MY CURRENT CHART. LY OPEN MY SELECTION PANEL HERE. I WILL CLICK ALL THEM ELEMENTS ON THE PAGE. CLICK, CLICK, CLICK. WE'RE GOING TO COPY THESE AND HOPEFULLY THE COPY WORKS. BOOM I I WILL TAKE MY ITEMS, BRING TO THE NEW PAGE AND REEARN THEM.
37:14
THE PAGE IS PRESET UP. THE LAYOUT IS READY TO GO. I WILL ADJUST SOME OF THE CARDS. FLIP THEM AROUND. THE RED LINES ARE AUTOMATICALLY POPPING UP -- LET'S ADJUST SO THIS MATCHES THE TOP OF THAT. MATCHES THE BOTTOM OF THIS. I'M GOING TO GRAB BOTH OF THEM. BRING THEM DOWN A HAIR. LET'S REARRANGE THESE OTHER CH CHARTS. GET HIM OUT OF THE WAY. I'M GOING TO GIVE ANOTHER TIP AND TRICK HERE THAT WE USE. THIS IS IMMENSELY HELP FFUL FOR YOU. YOU WILL BE DINING LOT OF THESE AS YOU
37:49
MAKE MORE REPORTS. A TRICK I LIKE TO USE, ONE THE IS RED LINES. YOU SEE IT'S SNAPPING IN PLACE. THAT'S A SETTING YOU TURN NONE THE FILE OPTIONS. IT'S BURIED IN THE MENU ITEM THERE. ANOTHER TRICK IS I'M GOING TO MOVE THIS OUT TO THE MID PART OF THE PAGE. WE'LL CALL IT THERE. IF YOU TAKE A VISUAL AND SNAP IT NEXT TO IT. SOMETIMES YOU WANT A THIN BORDER. ONE OF THE PRINCIPALS IS PROPER SP SPACING. IF YOU HOLD THE SHIFT KEY AND USE THE ARROWS AND NUDGE VISUAL. IF YOU JUST CLICK
38:33
THE ARROW KEYS IT NUDGES ONE SIXAL AT A TIME. YOU CAN TELL WE'RE PICKY AND PARTICULAR ABOUT GETTING THINGS LINED UP. I WILL TAKE THIS ONE VISUAL I WILL NOTCH IT TWICE. ONE, TWO. I KNOW THAT'S 20 PIXELS OVER. I HAVE MY SPACING THERE PROPER. I'M GOING TO BRING THIS TO THE OTHER SIDE EDGE AND LOOKS ABOUT THE RIGHT WIDTH I WANT. I WILL BRING THIS OTHER VISUAL. I WILL BRING UP TO THE UPPER CORNER ALIGNED ON THE RIGHT-HAND SIDE. I WILL GRAB THIS ONE, SHIFT, DOWN, DOWN. VY A NICE
39:08
CLEAN SPACE THERE. LET'S DO ANOTHER ONE. OVER HERE. NOW THIS ONE I'M GOING TO PUT AGAINST THIS AGE -- EDGE. THE BOTTOM EDGE OF THE ORIGINAL. SNAP, ONE, TWO, ONE, TWO. I WILL GRAB THE OUTER EDGES AND A LINE THOSE. ALIGN AND WE'LL SEE THE BOTTOM EDGE. YOU HAVE TO DO A BUDGE -- IF YOU CLICK ON THE VISUAL AND GO TO THE PAINT ROLLER YOU CAN ADJUST UNDER THE GENERAL SETTINGS. THERE'S AN X, Y WIDTH AND HEALTH AS WELL. YOU HAVE THE OPTION IF YOU WANT T . I FEEL THIS IS FASTER AND LESS
39:52
CLICKS. THERE WE GO BEEN SO I WENT FROM REPORT THAT WAS JUST OKAY IT DID -- IT GOT IS T JOB DONE NOW WE HAVE MULTIPLE PAGES, NAVIGATION ELEMENTS BUILT IN AND ABLE TO THEN CLICK ON EACH OF THESE THINGS IF I WANT TO NAVIGATE TO NEW PAGES IT'S BUILT. AND READ TO GO FOR ME. THAT'S ESSENCE BEHIND THE LAY O OUT. WE HAVE NUMBER OF LAY JOTS WE MADE PREVIOUSLY. I WILL POINT OUT ONE HERE. I'M GOING TO ASK A VERY -- HAS ANYBODY SEEN THE VISUAL ANY ANYWHERE? ANYWHERE AT ALL? DOCUM
40:33
DOCUMENTATION MAYBE? MICROSOFT HAS DONE DOCUMENTATION AROUND REPORT ATS AND THIS IS ONE THEY PICKED. THIS IS OUR SUNSET LAYOUT I'M PLEASED MICROSOFT PICKED IT. YOU WILL SEE THIS REPORT AND THIS IS THE ONE WE PRODUCE AS ONE OF OUR LAYOUTS. MORE RECENTLY IN THE ANNOUNCEMENTS THAT AMANDA DOES FOR THE POWER BI DESK TOP IS THIS ONE. HERE'S A BIT OF A FULL FLEDGED REPORT. WHY DO I WANT TO LOOK AT THE LAY LAYOUTS? WE DO A LOT OF SET UP, WE DO A LOT OF EXTRA THINGS THAT WE'RE ADDING
41:07
TECHNIQUE AROUND. WE'VE GOT 10 PAGES OF NAVIGATION WE MADE AT ALL TIMES BUTTONS AND WIRED UP. WE HAVE BLOCK AREAS. HERE'S AN EXAMPLE. YOU MAY WANT TO PUT A BIG VISUAL HERE AND A LITTLE VISUAL THERE. APPLYING RULES OF THIRDS. AND OTHER DESIGN PRINCIPLES WE ARE ALREADY IMBEDDING INTO THE REPORTS. GIVING GUIDANCE AND INSIGHTS TO HELP YOU WITH A COMPELLING LOOL LOOKING REPORT. EVERYONE INTERACTS WITH A NORMAL REPORT. WE HAVE FLY OUT MENUS WITH SOME OF THEM. >> WE HAVE A NUMBER
42:06
OF FREE REPORTS JUST LIKE THIS ONE. YOU CAN GET THEM, DOWNLOAD THEM AND PLAY WITH THEM ALL FOR FREE. THOSE OF YOU WHO HAVEN'T USED BOOK MARKS OR BUTTONS THIS IS THE INTERFACE OF WHAT MIKE IS SHOWING IS USING THE ELEMENTS TO ALMOST CREATE WEB LIKE EXPERIENCES IN SOME OF OUR REPORTS. YOU DON'T NEED TO OVER COMPLICATE THINGS BUT IT DEFINITELY GIVES YOU A LOT OF FLEXIBILIT FLEXIBILITY. THAT OVERLAY A REPORT THAT PROVIDES MORE DETAIL OF WHERE YOU CAN PROVIDE
42:40
THE CRAKESS OF WHERE ELSE WHERE WILL GO. THOSE ARE FANTASTIC FEATURES. THE OTHER THING TO NOTE WE USE, WE PUT TOGETHER SOME COMPLEX LAY OUTS AND VISUALIZATIONS. THE LAYERS AND SHAPES YOU CAN BUILD IN POWER POINT AND SAVE AS PNG AND UP LOAD AS THE BACKGROUND FOR YOUR POWER BI REPORTS ADDS WELL. >> IF YOU WANT TO SEE HOW THINGS ARE CREATED AND BUILT YOU CAN PULL APART OUR LAY JOTS. WE GIVE THE FINALIZED PRODUCTS AND CLICK THES. SEE WHEN THE BOOK MARKS ARE DO DOING. HOW
43:26
IS THE BOOKMARK CONFIGURED. THERE'S ELEMENTS HERE THAT ARE GREAT EXAMPLE DEMO AREA. >> [INAUDIBLE QUESTION] >> YOU CAN BUY ONE. WE LICENSE TO YOU FOR FREE FOR YOU TO USE AS LONG AS YOU WANT AND MAKE AS MANY REPORTS ON TOP AS YOU NEED. >> [INAUDIBLE QUESTION] >> SURE. [INAUDIBLE QUESTION] >> SO IN THAT EXACT EXAMPLE, THE QUESTION WAS, I HAVE A LAY OUTIN A TEMPLATE GUIDE IN POWER POINT WE HAVE GIVE PRESENTATIONS IN POWER POINT ALREADY. WE WANT TO DIGEST
44:39
THAT INTO LAY O OUT. THE TECHNIQUES AND STYLES I'M JUICING AS EXAMPLES. YOU CAN'T DIRECTLY IMPORT A POWER POINT BACKGROUND OR LAYOUT INTO THIS. WE WORK -- WE DO IT OURSELVES. YOU CAN WORK WITH A DESIGN TEAM AND SAY, I WANT SOMETHING THAT LOOKS LIKE THESE LAY OUTS. THESE ARE THE CHARTS I WANT TO GO. IF I WANT NAVIGATION ELEMENTS THESE WHAT THESE LOOK LIKE. YOU WORK ON THE ONE FILE AND SAVE AS A PBIT FILE AND THAT BECOMES THE FILE YOU SHARE WITH YOUR TEAM.
45:12
WHEN YOU START BUILDING REPORTS. START ON TOP OF THIS FILE AND THEY WOULD BRING IN THE DATA MODEL, SHAPE THE DATA AND BUILD THE REPORTS ON TOP. IT WOULD BE CONSISTENT THEN OPINION>> EXACTLY YOU'LL NOTICE TONALITY PAID ONES THERE'S NO VISUALS IN THE LAYOUT AUTOAL. IT'S PURELY TITLES AND TEXT AND STUFF LIKE THAT. IT'S GENERIC. THE EXAMPLES I'M SHARING HAVE DATA IN THEM AS A SAMPLE. THE TEMPLATES WE PRODUCE THERE'S NO DATA IN THOSE. IT'S EMPTY. >> YOU
45:50
HAD THAT SET UP IN POWER SNI SNIPPETY>> [INAUDIBLE QUESTION] >> YEAH. >> THOSE WILL BE IMAGES IN THE BACK BACKGROUND. >> [INAUDIBLE QUESTION] >> YOU WOULDN'T WANT THE USE AN IMAGE. THERE'S A PROPERTY ON THE PAGE IT ITSELF. THE PROPERTY IS WHAT YOU WANT TO PUT THE IMAGE ON OPINION>> YOU'RE GOING HERE. YOU ARE ADDING THE BUTTON CALLED IMAGE. MAKING THE IMAGE BIG, PUTTING TRANSPARENCY OTHER TOP OF IT. CLICK ANYWHERE IN THE WHITE SPACE, CLICK ON THE PAINT ROLE RE. YOU SHOULD SEE A
46:46
THING CALLED PAGE BACKGROUND AND A SECTION CALLED LOAD IMAGE IN THE MIDDLE OF THAT. THAT'S WHERE YOU WANT TO PUT THE IMAGES. >> WE'VE GOT ONE MORE COOL DEMO. SO MOVING FORWARD, WE TALK ED ABOUT CUSTOMIZIING PAGES, GOOD LAYOUT AND HOW YOU NUDGE THINGS OWE AND GET THE RIGHT PROPER SP SPACING. I'M GOING OFF THE RESERVATION HERE. WE'RE GOING TO GO DEEP INTO THE WE WEEDS. HOW MANY PEOPLE HAVE BUILT CUSTOM VISUALS? TWO. HOW MANY PEOPLE LIKE WRITING JAVA SCRIPT?
47:23
OR JAVA IN ANYBODY KNOW D 3SHGS DOT JS. LY SHOW YOU AN EASIER WAY. THERE'S A ANOTHER TOOL OUT SO ANOTHER ONE CALLED SECICALLY A PROJECT FROM MICROSOFT'S RESEARCH TEAM CALLED CHATICULATOR. I TOOK A PROS OF THE CODE AND BREATH TO MY WEBSITE. CHARTS DOT POWER BI DOT TIPS. THERE'S OTHER TOOLS IN THE GARDNER UPPER QUADRANT THIS ARE GOOD AT DOING HIGH LY STYLIE ICED. ANY DATA PROPERTY CAN BE APPLIED TO ANY VISUAL PROPERTY ON AN ELEMENT. THIS MEETS LOT OF THAT NEED AND
48:08
GIVES WILD FLEXIBILITY WITHOUT WR WRITING A LICK OF CODE. WE WILL GO THROUGH THIS NOW. I WILL GO TO OUR WEBSITE, CHARTS DOT POWER BI DOT TIPS. THIS IS THE TOOL. THERE'S A LOT OF ELEMENTS GOING ON INSIDE THE TOOL HERE. LY BUILD THE REPORT. THERE'S A REPORT CANVAS. WE HAVE A GLIF. THINK OF THE BAR YOU WOULD PUT ON A BAR CHART. THAT'S THE GLIF. THE REASON I LOOK AT THIS TOOL. THERE WERE CERTAIN THINGS YOU CAN DO WITH POWER BI THERE'S A COUPLE THINGS YOU CAN'T DO. SO IF I YOU
48:45
WANT TO CHANGE THE TRANSPARENCY OF A BAR AND DO OTHER -- YOU DON'T HAVE THE F FLEXIBILITY IN THE CURRENT VISUALS TODAY. THE CURRENT VISUALS NEED THE CAPABILITY TO DO THIS. THE MICROSOFT RESEARCH TEAM. YOU CAN ADD ALMOST ANY PROPERTY YOU WANT IN THE VISUAL. I WILL START BY LOADING SOME DATA HERE ON THE LEFT. REPLACE THE DATA SET. BRING IN A DATA FILE. IF YOU CLICK THE ELLIPSIS HERE ON THE LEFT HAND SIDE CAN I LOOK AT THE DATA PRESENTED ON THE LIST. HERE'S A BUNCH OF DATA.
49:24
REGION, STATES AND NUMBER FOR INCIDENTS AROUND DRUG, TRAFFIC, TRAFFIC ACCIDENTS. WHAT WHAT I WILL DO IS BUILD A STRUCK TRADITIONAL THINGS ON THE PAGE AND -- STRUCTURAL THINGS ON THE PAGE. THE GUIDES SNAP IMAGE STTO A SPECIFIC AREA. THE MIDDLE GUIDE WILL STAY IN THE MIDDLE OF THE PAGE. IF I ADJUST IT THE GUIDES GROW AND SHRINK WITH THE PAGE SIZE. >> PREDEFINED LOCATION ESSENTIAL LISTEN I CAN ALSO ADJUST THE PROPERTIES MANUALLY. THIS BAR CAN ADJUST THE BY THE WAYED
50:11
FWHITD THE BOTTOM RIGHT HAND CORNER. I CAN CHANGE THE WIDTH. A WIDTH OF 40. LET'S GO TO THIS ONE. A WIDTH OF 50 AS WELL. NOW I'M GOING TO ADJUST THE BARS ON THE TOP AND BOTTOM. THE HEIGHT IS 60. SAME ALT AT THE BOTTOM. THE REASON WE DO THIS AND LOCK THOSE IN THERE THE GREEN DOTS MEANS THEY'RE LOCKED. YOU CAN SEE AS THE VISUAL RESCALES THE ITEMS ALL STAY TOG TOGETHER. NOW WE HAVE THESE THINGS CALLED FL PLOT SEGMENTS. A TWO D AND 1D. I WILL ADD ONE DIMENSIONAL
50:57
PLOT SEG SEGMENT. I WILL GO WITH THE BOTTOM AND UP TO WHATEVER VALUE I WANT. THIS IS A ONE DMEJS PLOT SEG SEGMENT. THIS IS THE DRUG DATA TO THIS LINE, THIS ACCESS. NOW -- AXIS. NOW IT DRAWS ME ON A SCALE. IT LOOKS AT THE DATA SET AND SAYS WHAT IS THE APPROPRIATE SCALE FROM MINUTE TO MAX. I CANNED A AD JUST TO MINIMUM. LY GRDROP TO MINIMUM. LY CHANGE THE RANGE AT THE BOTTOM. RANGE TO ZERO. CHANGE THAT. FLIP THE AXIS HERE. FL FLIP TO THE OPPOSITE SIDE. NOW CAN I ADD VISUAL ELEMENTS
51:33
TO THAT LINE. I'M GOING TO ADD A MARK IN THE GLIF AREA. IT HAS A BAR. ADJUST THE PROPERTY TO BE A HEIGHT OF SEVEN. NOW I MAKE A MARK. SO EVERY TIME I SEE ADATE DATA POINT I WILL DROP A BAR ON THE LINE. WE CAN CHANGE THE COLOR OP OF THAT THING. CHANGE IT TO A COLOR OF BLUE. NOW THIS IS NOT HARD TO DO IN POWER BI. I CAN PUT NUMBERS ON A LINE AND I CAN PUT ITEMS ON THE BAR. THIS IS NOT REEOCKET SCIENCE. WLOOERS THINGS GET INTERESTING. BECAUSE THIS SHAPE HAS ADDITIONAL PROPERTIES.
52:13
WE HAVE A WIDTH, HEIGHT, SHAPE, FILL, STROKE OF THE TEXT. OH PASTY OF THE TEXT. I CAN DRAG OTHER ELEMENTS OR CHANGE THINGS ABOUT THIS. I CAN CHANGE THE OH PASTY AH PA PASTY. IF I HAVE OTHER FIELDS I WANT TO DRAG, I CAN ADD ANY NUMBER OF ADDITIONAL DATA FIELDS TO ANY OF THE PROPERTIES ON THIS ONE ITEM. AGAIN, TO BE CLEAR THIS IS H HIGHLY CUSTOMIZABLE. THIS IS WHY IT'S SO AMAZING TO ME. NOW WE'VE CHANGED THE TRANS TRANSPARENCY. ONE THING I'LL POINT OUT. WHY WE
52:49
CHANGE THE TRANSPARENT SIS ON THINGS IF YOU HAVE A SCATTER PLOT AND LOOK AGENT DOTS ON A SCREEN, IF THEY'RE SAME COLOR WHEN THEY OVERLAP I DON'T KNOW WHAT IS GOING ON OVER LAP LAP. IF YOU CHANGE THE OPACITIY ON THINGS I GET TO SEE A STACKING EFFECT. THE COLOR IS DARKER, DEEPER, RICHER YES THE -- IN THE AREA. VISUALLY WHILE I DON'T KNOW THE NUMBERS, THERE'S A DENSITY HERE. A DENSITY HAPPENING HERE. AND THAT'S WHAT TRANSPARENCY EXSENT WAITS FOR YOU DOING INDIVIDUAL DESIGN. >> THIS
53:27
IS THE FIRST PART OF OUR CHART. >> GO FROM THE TOP TO THE BOTTOM. WHEN YOU'RE MAKING LINE SEGMENTS OR LINE PLOT SEGMENTS THE DIRECTION MATTERS. IF YOU'RE DOING A NUMBER LINE IT WILL START FROM WHERE YOU START THE CLICK WILL BE THE LOWEST NUMBER AND THE END THE CLICK WILL BE THE HIGHEST NUMBER. AND IN THIS CASELY ADD A TEXT FIELD TO IT. LY ADD THE STATE OVER THIS THE AXIS. AND NOW WE CAN SEE THE DIFFERENT STATES OF THE UNITED STATES ON THAT LINE. I'M GOING TO CHANGE THE POSITION
54:08
TO OPPOSITE. BECAUSE WE DON'T NEED TO SEE THIS IN THE FINAL VISUAL WE WILL TURN IT OFF. WE WILL ADD ANOTHER GLYPH HERE. IT'S BY DEFAULT ALL GRAY. I WILL MAKE IT A HEIGHT OF SEVEN. NOW I'M GOING TO ADD A HEIGHT TO THIS BAR. THIS TIMELY NOT ADJUST THE TRANSPARENCY I WILL BURY THE DEPTH OF IT FOR EACH INDIVIDUAL MARK. LY GRAB THE DRUGS AND ADD TO THE WIDTH OF THE GLYPH ITEM. BOOM. NOW I'VE GOT BARS DRAWN. LET'S KEEP GOING. GO BACK TO THE SHAPE. WE WILL CHANGE THE COLOR TO BLUE.
54:46
WE WILL GO WITH DARKER BLUE. THIS WE GO. NEXT TIME -- WE WILL ADD TEXT. SO I'M GOING TO ADD ANOTHER LINE HERE IN THE MIDDLE. WE'RE GOING TO ADD ANOTHER GL GLYPHABI, ANOTHER LINE PLOT GOING FROM THE TOP TO THE BOTTOM AGAIN. THIS TIME I'M SCANNING GOING TO ADD A TEXT BOX. LY ADJUST THE TEXT LOCATION. IT WILL LET ME SEE I HAVE A TECHES BOX CENTERED. LY GRAB THE ITEM CALLED STATE AND ADD TO MY TEXT BOX. MY STATES APPEAR. YOU CAN SEE THEY'RE OUT OF ORDER. WHEN YOU PUT ON THE
55:27
OTHER AXIS ORDERED IN THE OTHER DIRECTION. S IN THIS IS MISALIGNED. I CAN DRAIN DRAG IT TO THE MIDDLE >> THE DATA ACCESS IS THE SAME AT AS THE NAME OF THE TEXT ON THE AXIS. VY TWO PLOT SEGMENTS THAT ARE PERFECTLY ALIGNED. THE TOP LEFT BEING A AL AND -- AL AND THE MIDDLE AS WELL. TURN THE ACCESS OFF. WE WILL CLICK ON THE PLOT SEG SEGMENT. WE WILL TURN THE ACCESS OFF. AND IS TEXT SIZE IS LARGE. SHRINK IT. SM SMALLER. YOU CAN RENAME ITEMS. THIS IS THE LEFT SIDE. THIS ONE IN NILLED IS
56:10
THE MIDDLE. THIS THIRD PLOT SEGMENT IS THE TEXT. NOW WE'VE GOT THREE ELEMENTS. NOW COMES THE MAGIC. THIS IS THE SFUF WE CAN'T DO ANYWHERE ELSE. THIS IS THE COOL PART. THIS IS WHY I'M SO THRILLED ABOUT THE TOOLING. WE'RE GOING TO CLICK THIS LINKS BU BUTTON. I WILL CLICK THE LEFT MIDDLE AND MAKE A BAND TO MATCH THOSE TWO TOG TOGETHER. WHEN I CLICK GO, BOOM. EVERYTHING LINKS TOGETHER. CHANGE THIS TO A SET TING TO [ INDISCERNIBLE ] CHANGE TO 160. LOOKS LIKE A MESS.
56:51
CLEAN UP A COUPLE OF THINGS. THE GRAY BARS I WILL REMOVE FROM THE PAGE. GO TO THE TOP. TOUGHER U TURN OFF. AND NOW I'VE GOT A NICE ORDERED LIST FROM ALABAMA TO THE BOTTOM. WE HAVE BARS IN THE MIDDLE. I CAN SEE RELATIVE SIZE BETWEEN THE STATES. I KNOW EXACTLY WHICH STATE I'M AT AND WHICH ONE IN THE LIST HAS GOT THE MOST WHATEVER. INCIDENTS IN DRUGS OR TRAFFICS. THE LINE IS WIGGLING OVER TO THE OTHER BAR. NOW I HAVE AN ORDERED LIST THAT LYNX TO THE
57:25
ORIGINAL ITEM. CAN I SEE DISTRIBUTIONS OF THE HEIGHT OF THE BARS. IN STAE TIC TIS TICKS WHERE YOU SEE YOUR MEAN, MODE, MEDIAN STATISTICALLY IN A LINE CHART. MAKE SENSE? ALL RIGHT. I WILL SHOW THE FINAL VERSION. WE'RE RUNG OUT OF TIME. I CAN BUILD OFF THE OTHER HALF. WE WILL REPEAT THE STEPPS FOR THE OTHER SIDE. I WILL SHOW YOU HOW IT GETS OUT. IT WILL DEPEND ON THE POWER BI. WE HAVEN'T TOUCHED THE DESK TOP PROGRAM AT ALL. THIS IS THE BEST PART. I'M
57:57
NOT GOING THE USE THE VISUAL HERE. I NEED TO BIND IT WITH MY DATA. WE'RE GOING TO BE ABLE TO EXPORT IT. IF I CLICK THE EXPORT BUTTON I CAN SELECT POWER BI VISUAL. AND CAN I ADJUST THE PROPERTIES OF THIS. LY GIVE YOU A CAVEAT. AXES AND SCALES. THIS IS SOMETHING A GOT YOU. WHEN YOU SET SCALES ON THINGS INSIDE THE CHART TOOL, CAN I SAY THE MINIMUM IS ZBERO AND THE MAXIMUM IS 60. WE SET THE PROPERTY FOR THE AXIS. SOMETIMES YOU WANT IT TO AUTOSCALE WITH YOUR DATA, SOMETIMES YOU DON'T.
58:31
SOMETIMES YOU MAY NEED TO ADJUST WHAT THE CHART IS DOING AND TURN THESE ON AND OFF TO -- IN MY REAL DATA SET I GO FROM 10 TO 20. THAT'S THE FERMENTS I HAVE. IF I TURN OFF AUTOSCALE THE SCALE WILL STAY FROM ZERO TO 06. NO MATTER WHATDATE PROVIDE TO IT. YOU'LL DO IT AND SAY THAT'S SO WEIRD IT DOESN'T WORK THE TAE I THOUGHT. THAT'S WHAT'S HAPPENING. >> TO THE BOTTOM. I'LL CLICK EXPORT TO POWER BI CUSTODY CUSTOM VISUAL. OKAY. I WAS JUST TALKING WITH ANOTHER
59:04
MVP. SHE SAID SHE WROTE SOME POWER BI R VISUALS. SHE WROTE A THOUSAND LINES OF CODE AND MADE A VISUAL. WE CLICKED, I DON'T KNOW 30, 50 TIMES IN A COUPLE OF MISSION. WE JUST MADE OUR OWN CUSTOM VISUAL WITH A LOT OF CUSTOM PROP PROPERTIES. LET'S PUT THIS IN DESK TOP. >> WHILE HE'S DARNING THAT. THAT'S AN IMPORTANT POINT TO UNDERSTAND. NEW TOOL, THINS IS ALL FREE. THIS IS JUST CREATING A CUSTOM VISUAL. THE AMOUNT OF TIME IT WOULD TAKE FOR YOU TO -- SOMEBODY
59:37
YOU KNOWS WHAT SHE'S DOING, TOOK HER TWO WEEKS? >> TWO WEEKS OF TIME TO WRITE A THOUSAND LINES OF CODE. >> SEE IF YOU INVESTED TIME ON THIS TOOL TO BUILD THESE THINGS OUT. THE VALUE THAT YOU'RE GOING TO GET FROM HERE IN BUILDING YOUR OWN CUSTOM VISUAL IS AS MENACE. IT'S A BIT MUCH. WE WANT TO MAKE SURE YOU WHAT YOU KNOWED THIS DOES DOES. >> ROW ONE, TWO, THREE. IN THE TOOL IT AUTOING A AGREE GATES EVERYTHING. IT'S DOING SUMS AND AVERAGES IN THE CHARTS TOOL. CHARTS TOOL. WHAT
1:00:32
WE NEED TO DO IS DEFINE WHAT IS THE GRANULARITY. HOW DETAILED. ZOOM HERE TO THIS TABLE YOU CAN SEE THIS MY DATA. I THE V THE STATE I HAVE A REGION AND I KNOW I HAVE TRAFFICS AND DRUGS HERE. THE MOST GRAN RATED IS THE STATE. THAT DPIENS A UNIQUE RECORD I WANT EVERY STATE TO SHOW IN THE MIDDLE. SFRI DATA MULTIPLE DATA POINTS PER STATE SKI K HAVE THAT. IT WILL AUTOAGGREGATE AS A SUM. I WANT TO EXPLAIN THE GRANULARITY THING. IT TOOK ME A LOT. WHY IS IT THERE. BACK TO THE PRETTY VISUAL.
1:01:20
I'M GOING TO GRAB THE YAWN L LAIRTY L LAIRTY -- GRANULARITY. I WILL GRAB THE STATE, GRAB THE DRUG DATA, TLRAFFIC DATA AND TAE DA. WE HAVE A PRETTY CHART. >> I CAN SEE OBSERVATIONS ALR ALREADY. LOOK AT THAT. WEST VIRGINIA, OHIO, PENNSYLVANIA THEY HAVE HIGH D DISTR DISTRIBUTION. TRAFFIC INCIDENTS. NOW CAN I LOOK AT THEDY TRI B BUGS. I CAN SEE THE DENSITY. CAN USE THIS TO INTERACT ACROSS OTHER VISUAL. IS CAN SELECT WEST, SOUTH OR NORTHEAST. FOR EACH
1:02:11
REGION CAN I EVALUATE CERTAIN ASPECTS. THIS IS TO OPEN YOUR MIND. THIS VISUALIZATION I CANNOT TAKE CREDIT. THERE'S A GENTLEMAN ON TWITTER. IF YOU HAVE TWITTER, TAKE A PICTURE AND TAG THANK YOU NICK SNAP. AND GIVE HIM A SHOUT OUT AND THANK YOU FOR THIS VISUAL. I USED HIS MATERIAL TO HELP DEVELOP IT AND BUILD IT. HE'S A GENIUS WHEN IT COMES TO THE VISUAL STUFF. I'M THRILLED WITH IT. IT'S COOL AND WORKS INSIDE THE DESK TOP. I FIGURE I WOULD SHARE WITH YOU AS WELL. IN YOU -- IF YOU
1:02:50
WANT TO GO OVER THE TOP WITH VISUALIZATIONS. WITH THAT WE'RE RIGHT ON TIME. THANK
Here to help you learn
Sign in to keep a private conversation with your course tutor.
Ask me anything about the material…
Sign in to chat