Crushing Your Goals with Power BI: Getting Started – Data Inspirations
5 lez/bi couples who are #goals If that isn't #goals, we don't know what is. for a while now, and have recently confirmed their relationship. If a bisexual person is in a relationship, why is it important they're still labeled as bisexual?. Bisexual men and women often enter treatment to focus on relationship concerns only to learn that providers don't know how to help them.
It's a huge part of who I am. I can't wake up and stop being queer. It doesn't work that way.
I woke up queer the day I met my husband. I woke up queer the day after we got engaged. I woke up queer the day we got married and every day after that. I'll go to bed tonight and wake up queer tomorrow, just like I'll go to bed tonight and wake up still married and still in love with a man who loves me for me, queer and all.
I still meet people who tell me bisexuals don't exist and it makes me crazy. Don't get me wrong, I struggle with self-imposed bi erasure like anyone else.
Sometimes I'm silent when I shouldn't be. Sometimes I hesitate before I use proper pronouns to talk about my exes. Sometimes I worry about what people will think about my husband for marrying a girl who used to date girls.
Bi Couple Goals! – The Bi-Fi Signal
But that's why it's important to me that I identify as bisexual, because I know there are countless others out there dealing with the same thing and visibility is key. My sexual identity is still extremely important to me. I have two primary partners who are female and I would very much like to have a boyfriend again.
My attraction to men has not lessened, and both of my partners are percent supportive of that. A bigger issue with me has been finding the time to meet quality guys. However, I never measured progress, thereby denying myself feedback.
Defining targets There is no shortage of information on the Internet to help you determine your goals. I am using Excel in this case, but I could have set this up in Google Sheets. Or I could use Access if I wanted to drive my data professional friends crazy. Whatever keeps the process simple and easy. As I thought about my targets, I decided I wanted to have categories for my goals because eventually I could expand this structure and add more goals per category. I also identified a frequency for each goal to differentiate between those I would track daily, weekly, or quarterly.
Therefore, I have to create my own data source and log my data for almost everything.
7 Myths About Bisexuality, Busted by a Bisexual Woman
Before committing to a structure for tracking my activity for all goals, I downloaded my Active Calories data by day to see what I could use as a starting point. I saved it to a Dropbox folder, but I have other options available such as emailing it to myself.
Now I need to capture the data for my other goal-related activities. As I complete an activity each day, I add a new row.
Bi Relationship Goals
Fortunately, Power BI is very good at that task. First, import the target data: Click Get Data on the startup screen if it appears. Otherwise, click the Get Data command on the ribbon. Either of the above options leads to the Get Data dialog box where I can select the source type. I then navigate to the folder containing my file, click Open, and then select the checkbox for the sheet containing my target values.
Next, I repeat the above steps with some minor changes: Because I had entered some data on my Actual sheet before I finalized the structure, Power BI brought in some additional columns that are empty and useless to me. Click the Finish Date column, hold down the Shift key, and click the last column with data Unit Type in my case. Right-click any of the selected columns, and then select Remove Other Columns on the context menu that displays.
Now I can import the health data. I do not want the Start column in the final results, so I right-click the Start column, and select Remove. I also do not need the Finish Date to have midnight included with the date. Now I need to get my health data to look more like the Actual data from the Excel workbook. I need to add a column to hold the goal name.
Bi Couple Goals!
In the Custom Column dialog box, I change the column name to Goal and then add an expression in the custom column formula box for static text that matches the goal name in the Target sheet, Hit move target daily Apple Watchas shown below.
Notice I put double-quotes around the static text. Click OK when finished. Now I need to move the column to the left to match the sequence of columns that I have for the Actual data. To do this, click the Transform tab on the ribbon, click the Move command, and select Left. I need one more column for the Unit Type. Last, I need to make the column names consistent with Actual, so I right-click the Finish column, select Rename, and then type so the column becomes Finish Date, and then I do the same to rename the Active Calories kcal column as Actual, as shown below.
I exported the data before the end of the day on January 7, so I really did hit my goal… for the record! My last data wrangling step is to combine the Actual and Health Data queries. On the Home tab of the ribbon, I click Append Queries. But… in the Actual column, some of my values are integers and some are decimal numbers, so I need to fix that and make the data type consistent across all rows by clicking the Actual column, clicking Data Type in the ribbon on the Home taband selecting Decimal Number.